yes and yes for above questions.

thank you... that helped!!

Using below VB Script, the values are being separated to 2 different columns(Numbers and Alphabets). The values I need are only Integers and not with decimals, alphabets..etc in the...

Absolutely not. It is for more than 200 M records and I need that to work in SSIS but struggling to get it.

In SQL, I'm using a function which...

Please, I need only Integers and in SSIS, thank you.

thank you!

The connection between all the tables is the ID "222". This will be same in all the tables.

Thank you for the replies!.. But I`m in a situation where I have almost 12 temp tables.

For example for 4 tables data the result should be as below for...

In Windows File Share Delivery method a File Name can be changed but for EMail Delivery method this do not work. Any options to change the File Name in Email...

It`s an example I posted here. I need to do it for multiple procedures.

I need to ALTER both the stored procs at the same time with below SQL.

Table2 t2 ON t2.CID = t1.CID

INNER JOIN Table3 t3 ON t3.CID = t1.CID

WHERE CustGroup = 'Employees'

After...

Thank you!.. I only had order by cdate desc and not "order by CID, CDate desc".

It works and also I have to set the Delay Validation to TRUE. Thank you so much!....