I have tried fill factor of 60, 75%, 90%, and currently 0.

at 0 fragmentation is 25% after rebuild, at 90% it was over 30%, and 75% it was 28%.

Did I...

And the SQL Agent account has permissions to write to the folder?

Do you have Integration Services Service running on the server you are trying to run the package from? 

I also tried changing the field in the destination table to 1500 length nvarchar and am still getting the truncation error.  I am not sure what the issue could be...

Forgive me, but I am not sure what you are asking.  Are you saying I could just change the destination table to nvarchar?  I am trying to get away from...

Make sure you have MS-DTC enabled on your Windows 2003 server.  It is not installed by default.

Thanks guys, somehow I missed that. 

Is there a way to encrypt the passwords that show up in the configuration file?

Someone in our group found out the problem.  You have to set the tcp port 0 and make it dynamic.

Thanks Rich.

I did some poking around in Oracle datatypes and found you can also select the count back as a numeric datatype.  Numeric datatype in Oracle will match to the...

If you look at your connections in the Package designer do they show up as variables?

Sunil:

I am still finding my way around Integration Services, but I think this will help...The config file can be changed manually, or if you create a deployment utility when you...

Thanks for all your help!  Also, your blog has been a big help in coming up with strategies for our implementation of Integration Services.

Thanks, Erich

Do you have the flat files on a central server?  How do you run your packages?

Thanks for the reply,

Erich

If you are talking about actual jobs in SQL Server 2005, you can migrate jobs from server to server using Integration Services.

Thanks for the tip!

-Erich