Background: I have about 170 SSIS packages. A new requirement is that users from other workstations can run them from their command lines using dtexec. Question: To make this possible I'd like to set change the protection level to encrypt sensitive with password, and change the password in each package. Is there a way to automate th...
I am in the process of exploring integration between SSIS and IBM MQ Series. Can some point me to some artical for integration. ...
Hi, I would like to ask if there's a known issue with the FTP Task of SSIS 2005 on UNIX servers(HP UX B.11.23.). As per checking, we were able to ftp files on Windows Server but not on Unix. Though I can browse the ftp path of the UNIX server from my windows exlporer. I can even manually copy files. But when I tried uploading file thru S...
I have an Execute SQL task (SQL 2008) where I'm using two SSIS variables to interact with an Oracle database: DECLARE ParamTest number; TempOutputRun varchar(255); ParamTest := ?; TempOutputRun := ?; BEGIN IF ParamTest = 0 THEN SELECT CAST(OUTPUT_RUN_ID AS VARCHAR(15)) AS OUTPUT_RUN_ID FROM GL_EXTRACT_STATUS WHERE STATUS='NEW' ORDE...
Initially I deployed packages on SQL server but since my machine is not having SSIS installed I faced issue of version while executing the packages. Then I deployed packages to file system on server which has SQL server enterprise edition with SSIS installed on it. I access the folder on server where I have deployed packages from my syst...
I tried creating a new SSIS package and when I tried Doping a Data Flow Source (say OLEDB Source). I get the error The Component cannot be added to the Data Flow task. With the following Additional information ADDITIONAL INFORMATION: Interface not registered (Exception from HRESULT: 0x80040155) (Microsoft.SqlServer.DTSPipelineWrap) ...
Till now I've been exporting data INTO the SQL Server CE database, but now in SSIS I'm attempting to source data that was inserted in a previous step of the import. The SSIS fails during validation with the following error Error: Microsoft.SqlServer.Dts.Runtime.DtsCouldNotCreateManagedConnectionException: Could not create a managed con...
Hi, could anybody give me any clue why this script not doing the job to write the file? in fact when i'm trying to run it on SSIS 2005, the task showed up green and success I'm confused Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports System.IO Public Class ScriptMain Public Sub Ma...
If I run a package from the Management Studio, and specify a configuration file, everything works as expected. I can also set the package to get it's config path from an environment variable, and that approach works as well. However, if I try and run the package from the command prompt with DTExec I get the error: Cannot load the X...
I have data which resembles the following: "D.STEIN","DS","01","ALTRES","TTTTTTFFTT" "D.STEIN","DS","01","APCASH","TTTTTTFFTT" "D.STEIN","DS","01","APINH","TTTTTTFFTT" "D.STEIN","DS","01","APINV","TTTTTTFFTT" "D.STEIN","DS","01","APMISC","TTTTTTFFTT" "D.STEIN","DS","01","APPCHK","TTTTTTFFTT" "D.STEIN","DS","01","APWLNK","TTTTTTFFTT" "D...
i'm using Sql Server 2008. There are options to run from command line. Is there a way to execute an ssis package using sql statement? -Vivek ...
I have data which resembles the following: "D.STEIN","DS","01","ALTRES","TTTTTTFFTT" "D.STEIN","DS","01","APCASH","TTTTTTFFTT" "D.STEIN","DS","01","APINH","TTTTTTFFTT" "D.STEIN","DS","01","APINV","TTTTTTFFTT" "D.STEIN","DS","01","APMISC","TTTTTTFFTT" "D.STEIN","DS","01","APPCHK","TTTTTTFFTT" "D.STEIN","DS","01","APWLNK","TTTTTTFF...
I’m looking for some feedback on mechanisms to batch data from MySQL Community Server 5.1.32 with an external host down to an internal SQL Server 05 Enterprise machine over VPN. The external box accumulates data throughout business hours (about 100Mb per day), which then needs to be transferred internationally across a WAN connection (qu...
I'm running an SSIS package from an external scheduler (Control-M), using dtexec. I'd like to provide different error codes to the scheduler based on which part of the package failed. Is there any way to set the return code of dtexec on package failure? If not, does anyone know of another way to communicate a status back to the schedu...
In SQL Server Integration Services 2005, how do I read a directory so I can then process all of the files in that directory? ...
In SQL Server 2005 Integration Services, how can I automatically trigger a restoration of a transaction log backup file? ...
Hi, I have an xml file the content which i have to write to a Database table using ssis pacakge dataflows. I am using xml source and oledb destination. My issue now is this xml file generate multiple outputs .(event,produt,offer,form) etc. But i need to write all in one data row(more than one if 2 products are there for the event) in...
How do you check to see if a file does not exist in SQL Server Integration Services 2005? Is there a native SSIS component which will just do this for you? ...
How do you get a timestamp from a file with SQL Server Intergration Services 2005? ...
This question is in respect to the script component specifically. I am aware of ssisUnit etc… With simple SSIS Scripts Components, it’s sufficient to let basic testing flesh out issues, however I am working with a script that has grown in complexity over time. To better test the functionality I am considering abstracting the script lo...