April 8, 2010 at 1:31 pm
I want to load the data from SQL 2008 to AS400
For connecting to AS400, I am using the ADO NET Destination component with an ADO.Net Connection Manager that uses ODBC DSN
Inside the ADO.NET destination editor, I did the following:
1. Connection manager: AS400 connection
2. Use a table or view: "libraryname"."@Product"
when I click on preview, I get the below error:
The table or view name is not valid. Please use the table prefix " and suffix " of the data provider if you are quoting table or view name.
Since I am using this AS400 file "libraryname"."@Product" which has @ before Product, this is erroring out.
If I use a table without the @ sign, then I do'nt get this error and it works fine.
We can't change the AS400 file names , so how do we handle such filenames which has @ sign in SSIS?
Actually some of our old DTS packages uses such files which has @ sign and DTS runs fine with no errors.
Please, any ideas. Thanks.
April 9, 2010 at 7:14 am
I have windows 2008, 32-bit OS and SQL Server 2008.
When I am trying to use Execute DTS 2000 Package Task for the purpose of inserting data to AS400, I am getting the below error:
REquires SQL Server 2000 data transformation services (DTS) runtime.
But I tried to install it did'nt work, since I have windows 2008, do I need to do anything special in order to install
SQL Server 2000 data transformation services (DTS) runtime component.
Please advice. Thanks.
April 11, 2010 at 11:46 pm
Why don't you use the OLEDB Provider for the connection to the Database on your AS400?
I have used the OLEDB for DB2, not on an AS400 platform...
As far as the SQL Server 2000 run time error check out the following link:
http://msdn.microsoft.com/en-us/library/ms143755.aspx
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy