Using linked server with select into will lock the table right until the insert is done? The server that the data is finally moved to is used for reporting...

Good question. It is a third separate machine. So is the data brought into a buffer on this third separate machine? Please let me know?

Thank you!

Thanks for the suggestion. I have tried this. Always wondered what table / view fast load meant.

Best wishes,

Monisha:-)

Yes, it is. If I manually copy the file over and import into the database using excel connection it works perfectly. Only the FTP process does not retrieve...

I examined the values in the column causing the problem. It was a 1 E 18 value that was causing the problem. Changing the datatype of the destination...

I redirected the error output to a table on SQL server and the table after the job failed had no data. I am not certain why that happened. ...

How do you add the destination to capture the redirected rows? Can u please let me know? I am setting the option to redirect the output on failure.

Any...

The datatype in SQL Server Destination is numeric(38, 0). How do I redirect the error rows? Any inputs will be much appreciated.

Best regards,

Monisha

The exe just runs a report on cognos reportnet server. It does not bring up any form or dialog box.

I remember reading that the number of database...

I figured this out. The datasource is SQL Server 2005. The problem is not with the data it is with Excel. For text fields excel prepends...

I am using a blank sheet each time and I am using excel destination so there is no logic involved.

Thanks.

Thanks the IMEX=1 tag at the end of the connection string worked like a charm.

Manisha

Did you encrypt your package with a password? In the package properties set the ProtectionLevel to EncryptAllWithPassword and specify the package password. When deploying on the server when...

Thanks that helps.

The windows compact command with the /u option does not seem to work:

C:\Documents and Settings\Administrator>compact /u "C:\ETL\POSData\IngramWeekly

INVEN.ZIP"

 Uncompressing files in C:\ETL\POSData\IngramWeekly\

0 files within 1 directories were uncompressed.

Any other inputs will be...