I've created a SSIS package, in which I'm calling 2 sp's with a single parameter each. So how to call this package inside a stored procedure by passing a value to as parameter to that package and stored procedure dynamically. ...
Hi folks, I am struggling with an SSIS (SQL Server Integration Services) related problem for over two days now, so I decided the ask you. ;-) Following Setup is given WebServer / Application Server Database Server with SSIS The Database Server is also hosting a webservice that does calls local SSIS Package. When calling the webserv...
In my SSIS package, I want to see if a particular Oracle view has data in it. I have a Execute SQL Task with a select count statement: Select CAST( count(*) as Integer) As Row_Count from OWNER.VIEW_MV My RowCount is in the Result Set, pointing to my Variable User:TableCount. If I set TableCount to anything except Object, I get an err...
Hi, I am using npgsql as the ADO.NET provider in SSIS to connect to Postgres and create some workflows. I am able to connect to postgres but am unable to use the "Table or view" data access mode to list the tables and views. I have to resort to using "SQL command" data access mode. For the "table or view" access mode, the log shows tha...
Is it possible to pass the parameters of a stored procedure, when the stored procedure is being executed from an Integration Service Package. Ideally I would like the value of a variable defined inside a SSIS package to be passed as parameter to the stored procedure. Is it possible, if so how? ...
I have a Send Email Task in my DTS Package OnPostExecute event. It sends email to the developers after this package gets executed. It works but the problem is it sends the same email twice. Am I missing something? Thanks! Ryan ...
We have a SSIS 2005 package that is installed on a central server and is called from multiple locations. This package uses a script task to call a .NET DLL which I wrote in c# and installed into the GAC on the central server. When I call the SSIS package from that server on which the package is installed everything is fine. When I call ...
Hi, I have an SSIS package with a .dtsConfig file. When I run the .dtsx package using the 'Execute Package Utility' then settings from the dtsConfig file get applied fine. However, when I try and run the SSIS package from an ASP.NET page the settings in the dtsConfig file are not applied. Anyone know why this may be? Many thanks! An...
How can I detect control files from any mailbox, scan that file, decrypt it and queue it as a job using job manager in SQL Server? ...
We are evaluating SSIS to see if it will be appropriate for a new project that is coming up. One of the processes will have to process a flat file with delimited records. The file will contain orders. There is a header line, an (optional) shipping address line, and one or more detail lines. Each line's fields are delimited but are no...
Is it basically possible to do transactions with ssis and ms access 97! I have tried setting up a complicated package which doesn't work and then tried some transactions with a simple package which worked no problem with sql server to check I understood the principles. Now the question is does ms access support or does ssis support trans...
Based on the example here from MSDN, how could one provide SSIS package level variables if one were to invoke the package via "sp_start_job" procedure? Here is the example code from MSDN: Dim jobConnection As SqlConnection Dim jobCommand As SqlCommand Dim jobReturnValue As SqlParameter Dim jobParameter As SqlParameter Dim jobResult As ...
I have this small code using SQL Server Agent to Run a Remote Package Programmatically on the Server. But the problem with the code is that even if the job out come is failure, but job was executed successfully. so this program always works fine. I want to know if I can actually capture the job result in C#.. Any thoughts? namespace L...
While creating an SSIS package for SQL Server 2008 i run into the following error: Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running. I...
We have a some ETL processes that read CSV files that are output from SAS programs. I'm in the process of upgrading one of these ETLs and was wondering if I could use SSIS to read directly from the SAS dataset. Has anybody done this successfully? ...
Hi, I am executing my SSIS package in VB.net. In my local machine when i execute the code it works fine and when i deployed into my server, it fails sometime....Mostly its executing but sometimes it says Package execution failed. Here is my piece of code......... Can anyone tell me what went wrong here..... Dim pkg As Micro...
I am importing from an excel spreadsheet and it is not allowing me to change the source column type from Double to Unicode string. I have tried using "IMEX=1;" in the connection string but this appears to be doing absolutely nothing. The package refuses to validate and when i execute the package therefore will not run, and it keeps wan...
Hello Im using OLE DB Source for get rows from a dBase IV file and it works, then I split the data and perform a group by with aggregate component. So I obtain a row with two columns with "null" value : CompanyID | CompanyName | SubTotal | Tax | TotalRevenue Null Null 145487 27642.53 173129.53 t...
I am working on implementing an SSIS package in SQL Server 2005 which deals with XML files. Multiple XML files will be read-in from a directory on the file system and data from each XML file will be imported into a database table. The XML to database row works fine and I can iterate over all *.xml files in a specific directory. I hav...
I've created an ADO.NET connection manager, and a DataReader source with the following SQL Command: select 'test' as testcol INTO #tmp select * from #tmp If I click the refresh button in the DataReader component, I get SqlException "Invalid object name #tmp". The SQL statment itself is clearly valid and executes properly in s...