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.