Hi,

If you have ole db destination, then there is keep identity checkbox in editor. This will also copy the identity property from source. Why r you using datareader source ?

VG

Hi,

I don't have complete code for you...You need to read more on this..I can help...

Anyway, what you have ahead of script component, what is input to your script component ?

...

What kind of transformation/task the package does ? Are you sure the source table in Test server has data ? Somethings in DTS may not work is SSIS. You need...

ActiveXscript task will be removed in future vesrsion. So, we have to use script component transformation. As suggested it is different than DTS versions.Its better read about it and proceed.

you...

Hi,

Did u try using dataviewer in between source and data convesrsion transformation, jsut make sure its outputting data. double click the green arrow and add data viewer. Now execute the...

I am not sure this is how it is...As I have given these permissions on DEV environment, not production though.

I have a user with public server role. He has dbo...

Great!!! You proved it works......

VG

Thanks Brandie..your points really highlighted our security protection, which we don't have. Hmm let me read more on BOL, may be will go for SQL server, since our connection involves...

Hi,

We also have similar situation...we develop our packages on DEV and move on to UAT and then to production. It is not clear for me what are the advantages of...

Hi,

I think there 2 solutions here:

1. You copy a blank template file after your FTP process. OR

2. In flat file destination property, select validateexternalmetadata to false. So, your validation...

Hi,

I know DTUTIL utility can help...I haven't used this you need to find more information on this...

dtutil:

You can use the dtutil command prompt utility to manage existing packages at the...

Hi,

The error u r getting may be brcause it may not able to map between source and destination. R u sure all the files have same columns?

I don't know why...

Hi,

You can edit the flatfile output column width, in falt file connection manager. Make column output width same as table column width for that column.

MAke sure, you have defined...

Hi,

ON MAnagement studio, connect to Integration services.Under stored packages, look under msdb folder. IF it is saved in msdb, which is the default location for SSIS packagesare, when you saved...

Ohhh, I had the server IP address wrong..My mistake...

VG