September 21, 2011 at 12:20 pm
Marios Philippopoulos (9/21/2011)
Do any of your data sources in the job (DataSources tab) use sql auth to connect to the instance? If yes, you will need to manually re-enter the passwords in the conn string:...;Password=xxxxxx;...
Hi, In the DataSources tab, I added the Password.
It looks like I need to modify the command-line arguments, any idea how.
It gives me error argument '***' for option 'connection ' is not valid.
September 21, 2011 at 12:27 pm
SJanki (9/21/2011)
Marios Philippopoulos (9/21/2011)
Do any of your data sources in the job (DataSources tab) use sql auth to connect to the instance? If yes, you will need to manually re-enter the passwords in the conn string:...;Password=xxxxxx;...
Hi, In the DataSources tab, I added the Password.
It looks like I need to modify the command-line arguments, any idea how.
It gives me error argument '***' for option 'connection ' is not valid.
You need to provide an actual, valid password for that login.
Can you send me the connection string?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 21, 2011 at 1:05 pm
Hi, In the DataSources tab, I added the Password.
It looks like I need to modify the command-line arguments, any idea how.
It gives me error argument '***' for option 'connection ' is not valid.
You need to provide an actual, valid password for that login.Can you send me the connection string?[/quote]
These are the connection strings for the source connection manager and the target connection manager--> (I havent changed the complete names of the server, just had put XXX in some parts)
The error i get is argument 'AGO' for option connection is not valid
Data Source=AGO-XXX-XX-001;User ID=XX; Password=bmcsdeSA1;Initial Catalog=XXX;Provider=SQLNCLI10.1;Application Name=SSIS-Package-{A57C69EC-2A78-4EFE-A537-B5EDCEEF9164}AGO-XXX-DB-001.SDE.sa;Auto Translate=False;
Data Source=AGO-XXX-XXX;User ID=omlWeb; Password=oml@2011;Initial Catalog=XXXX;Provider=SQLNCLI10.1;Application Name=SSIS-Package-{37663EFE-C430-4C96-9282-6AC9473DF238}AGO-WEBAPP-006.OML_Determinations.omlWebUser;Auto Translate=False;
September 21, 2011 at 1:19 pm
Try this:
Data Source=AGO-XXX-XX-001;User ID=XX;Password=bmcsdeSA1;Initial Catalog=XXX;Provider=SQLNCLI10.1;Persist Security Info=True;
(ie. no space before "Password").
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 21, 2011 at 1:24 pm
One more thing: get rid of the dashes in the "Data Source" name.
This might very well be the issue.
I have had this issue with the "-" characters before.
Best not to have any special characters in the datasource name.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
September 21, 2011 at 2:08 pm
Marios Philippopoulos (9/21/2011)
One more thing: get rid of the dashes in the "Data Source" name.This might very well be the issue.
I have had this issue with the "-" characters before.Best not to have any special characters in the datasource name.
Thank you so much! I renamed the DataSources to a simple name and it worked!!
September 21, 2011 at 2:14 pm
Glad it worked! I have been burned by this before... 😉
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 7 posts - 31 through 36 (of 36 total)
You must be logged in to reply to this topic. Login to reply