Re: OLE DB Connection in SSIS Package does not remember password
Mon, 21 Jul 2008 17:08:36 -0700
I had this same issue with SSIS in 2005. Had nothing to do with the
ProtectionLevel setting.
I had changed the name of the Source and Destination connections to be
more meaningful than the SSIS IMport?Export wizard default names. It
appeared to work as the new connection names did appear in the Source
objec ...
|
DTS packages in SQL Server 2005
Mon, 21 Jul 2008 15:04:01 -0700
I understand that DTSRUN is not supported in pure 64 bit. Is it supported
under X64 (ie just runs as a 32 bit app) ?
thanks
Peter ...
|
Nomalization Tasks
Fri, 18 Jul 2008 11:40:06 -0700
Hi Everyone,
I'm sure i have a fairly simple question but i'm pretty new to SQL2K5 SSIS.
I'm looking to see the best approach to normalizing some SQL tables I have.
I want to extract the distinct types and then link the new type id back to my
account table.
For instance i have table as such
Account# ...
|
help on email the exported results through DTS (SQL2K5)
Fri, 18 Jul 2008 06:51:05 -0700
Hi,
I'm wondering if this can be done.
DTS will export query results into a flat file, is it possible to continue
to email this flat file?
Thanks a lot,
Sarah ...
|
AcquireConnection method call to the connection manager "myServer"
Fri, 18 Jul 2008 04:03:00 -0700
I have an SSIS package which has for each loop, inside the loop 3 parallel
tasks should execute which are linked to another task.
Whenever I run the package, I get the following error in the Execution
results "The AcquireConnection method call to the connection manager
"MonitoredServer" failed with error code ...
|
DTS / DTSRun - Permissions - [SQL2K]
Thu, 17 Jul 2008 12:04:28 +0200
Hello,
I know how to use DTSRun.exe.
I also can redistribute only the files for DTS (as indicated in redist.txt) for
a normal client, which does *not* have the full SQL Server Client installed,
and then the normal user can execute DTS-packages. This works.
But now we use a terminal server on which several u ...
|
After Insert trigger copy rows to a file
Thu, 17 Jul 2008 01:04:00 -0700
I would like all records inserted into a database table to be copied into a
text file. (A 3rd party application will move this file and import the
records into another database).
I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a fi ...
|
|
|
SQL Server Agent - Error 1326
Wed, 16 Jul 2008 14:04:16 -0700
Without having to recreate this processing in SSIS, I have an existing
Access program
which I can run by commandline. The batch file runs an AccessDB executing a
specific macro.
I created a job in SQL Server 2005 with a step type "Operating system
(CmdExec)" to execute the batch file. When I run the job, ...
|
parameterize query in SSIS package - SQL 2005
Wed, 16 Jul 2008 09:00:01 -0700
Hi All,
I have created a query to run in a .dtsx package.
I would like to parameterize it so that a user can input a value via the
Execute Utility dialog when the .dtsx package is double-clicked.
Any info would be appreciated!
Thanks,
Gloria ...
|
DTS package calling a stored proc failing
Wed, 16 Jul 2008 12:08:28 GMT
We are running SQL server 2000 with DTS. We have a stored procedure which worked fine for quite a while. We had to change it recently and since then it fails when being run from a package. it works when run from embaracdero ro sql server enterprise manager, but when run from the package it fails. We backed out the c ...
|
