Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2010-04-08 : 15:37:57
|
| I want to load the data from SQL 2008 to AS400For 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 connection2. 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. |
|
|
|
|
|
load data from SQL 2008 to AS400