But I have to do it in a stored procude while selecting the source data,,Is it possible in a stored proc?

Thanks

Ohkk..Yes but I am using a Stored Procedure and have to do it in a select query...

Thanks a lot... Phil..Erik

it works....... 😎

I have one more question,

Is there any way to split this long string into columns partitioned by DOTS

For Ex:

ab.cd.ef.gh

gives

Col1 Col2 Col3 Col4

ab...

@Phil,

Yes, but it is not just 2 characters, it can be in any number...

ex:

w.e.r.t

ff.g.h.tr

thanks

Thanks,

I got the replace to remove dots but how do I remove the first and last characters...

SELECT REPLACE('ab.cd.ef.gh.kl','.','')

SELECT REPLACE('hh.jj.kk.rr.ee.bb','.','')

Result:

(No column name) ...

Thanks a lot Steve,

I think last option is the best,yeah I already have staged the source data and will try now to join it in the OLE DB source query...

Hi Steve,

Thanks for your reply...

I have to do this process on a weekly basis to check if something has come new or something has changed in the source for this...

Thanks a lot GSquared....

From what I got is

I will have to add checksum column for each column that may change in my source in both the places....

Source as well as...

any help?

Hi Phil,

thanks for your Reply.

Actually I have a very large dimension table that is updated but not very frequently......

So I cannot check for every row if some thing as changed...

Thanks for the information,

I went for the exam today and passed with 899 marks...........

This is my first certification......

Very Happy to be an MCP...................

Congrats..!!

Thanks for the information

I have to take exam next week.

Let me know if you have some study material...

Thanks

tHANKS

I have started the service MSDTC..

but now it fails saying that unable to ACQUIRE CONNECTION OLEDB.

Actually it works fine if I remove required property from SEQ container tX but fails...

I have to log the following in a package :

PackgStartTime

PackageEndTime

Rows Inserted

Rows Updated

Any help?