Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SSIS Not pulling data correctly
I know it is not permissions. It is always running under my user ID. If it was permissions, then I would be rejected from writing to the file all together. This is not the case. I am writing the file on each box. The production box is just writing incomplete data. It seems that character...- clumnah
- Post #5
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS Not pulling data correctly
The pacakge is exactly the same. I am not running a copy of the package. I am putting the package onto my production server. Running it there and watching it not work properly. I am going on my machine and the test machine and navigating to the folder where the package sits on the production...- clumnah
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS Not pulling data correctly
Ok I wrote a SSIS package that will pull down data from my AS/400 and populate a SQL Server table with the data. 1)The data is being pulled from my China configured AS/400. It is configured to handle DBCS 2)The SQL Server tables are configured to handle DBCS by using the nvarchar datatype...- clumnah
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Integration Services (SSIS)
