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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-08-07 : 03:47:11
|
| What is wrong with the following query please?dtexec /f d:\sysappl\CEM\SSIS\Imports\Trades\BaseProfiles2.dtsx /set \Package.Variables[User::FileName].Properties[Value];"d:\ApplData\CEM\WorkingTemp\profiles.csv" /set \Package.Variables[User::ConnectionPath].Properties[Value];"Data Source=servername1\instancename1, 2025;Initial Catalog=databasename1;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;"The error is:The identifier that starts with 'Data Source=servername1\instancename1, 2012;Initial Catalog=databasename1;Provider=SQLNCLI.1;Integrated Security=SSPI' is too long. Maximum length is 128.I believe it is to do with the double quotes for the connectionPath variable but not sure how to solve the problem.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-07 : 13:09:57
|
| Replace servername1\instancename1 with ip address may get you right number. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2007-08-08 : 03:17:32
|
quote:
Originally posted by rmiao
Replace servername1\instancename1 with ip address may get you right number.
tried that but still the same error.Thanks |
|
|
|
|
|
|
execute with double quotes