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 |
|
aakcse
Aged Yak Warrior
570 Posts |
 Posted - 2009-05-12 : 07:21:51
|
| Hi all,I am new to SSIS,I am facing the problem to load multiple flat file to sqlserver table.It's giving 2 errs saying 1. "The connection string format is not valid " it must consist of one or more components of the form x=y, separated by semicolons.error at package: the results of the exp @user::variable on property connectionstring cannot be written to the property, the exp was evaluated but cannot be set on the property.2. cannot be processed because more than one code page ( 65001 and 1252) I have changed the code page to 65001 in connection manager and in execute sql task object Regards,aak |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-05-12 : 16:08:23
|
| Please post your connection string. |
 |
|
|
|
|
|
The connection string format is not valid