Hello all,

I' ve created a dts package to import some data from another data source.
I've created an SQL connection and specify the provider 'Microsoft OLE DB
Provider for SQL Server'. I parameterize the ServerName, User, Pwd and DBName
and set their values using an activex script. When I run the dts on SQL
Server (in Design Mode) completes successfully, but when I run the package as
a structure storage file, on the first task that executes a stored procedure,
the package fails with an error:
Error: -2147217843 (80040E4D)
Error string: Login failed for user 'sa'
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0

My password is simple (for now): 123
command line: dtsrun /FD:\AccessDBPath\MyPckgName.dts /NMyPckgName /Mpgkpwd
/LD:\AccessDBPath\DTSErrorLog.txt
/AParMDBFilename:8=D:\AccessDBPath\AccessDB.mdb
/AParServer:8=MYSERVER\MYINSTANCE /AParUserID:8=sa /AParPwd:8=123

Do you have an idea what might cause this? Maybe I have to specify the
provider again (in my activex scipt)?????

Thanks in advance.

No reason for this to fail. Check the names when using global variables,
names are case sensitive.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"x-rays" <xrays (AT) discussions (DOT) microsoft.com> wrote

Hello Darren, thank you for your time to answer me, but unfortunatelly it
doesn't work and my parameters are written correct.

------------------------------------
God, what is it?

"Darren Green" wrote:

Well you were right Darren, I confused, I had so many errors. my problem was
my password that had be enclosed in double quotes.

Thanks again.

"x-rays" wrote: