all groups > sql server dts > july 2007 > threads for july 29 - 31, 2007
Filter by week: 1 2 3 4 5
DTS package run from a SSIS Master package
Posted by RK at 7/31/2007 8:00:02 AM
Hi,
I am quite new to SSIS but inherited a package written by my predecessor to
maintain. The SSIS Mater pckage runs nearly 6 to 7 DTS packages within it.
DTS Package A was one of the child packages run within the Master package.
This package A is available in the Legacy folder in the SQL 2... more >>
Batch File in DTS
Posted by thanksforhelp at 7/30/2007 3:12:02 PM
Hi,
I have a batch file, copies a xls file for one dir to another and delete
source file. This works in DTS package, but when I schedule the package, it
fails.
Any help in ver much appreciated.... more >>
ssis
Posted by farshad at 7/30/2007 5:52:05 AM
I would like to run a ssis package and pass the filename as the parameter to
the package.
This is what I have worked out so far but notice the error message:
xp_cmdshell 'dtexec.exe /f
"d:\sysappl\CEM\SSIS\Imports\Trades\CounterPartyExposureEquitiesImport.dtsx\EqRonnieHK.csv"'
p.s. If I r... more >>
execute ssis in sql
Posted by farshad at 7/30/2007 3:04:00 AM
Hi,
Using SSIS, how is it possible to execute another ssis package and pass a
parameter to it?
For example, I would like to have a sql code that runs the package say
"d:\sysappl\CEM\SSIS\CSA.dtsx" and pass a parameter of fileName because the
CSA.dtsx package requires a filename.
Something... more >>
Execute an SSIS Package from a Stored Procedure
Posted by C at 7/30/2007 2:54:02 AM
Can I call an SSIS Package from a Stored Procedure?... more >>
error column
Posted by farshad at 7/30/2007 12:02:00 AM
Hi,
Using SSIS, while importing (source i.e. .csv into destination i.e. sql
server table), how is it possible to log the source COLUMN which causes the
error in the row?
Thanks... more >>
|