I'm writing a Custom SSIS task that, as one of it's functions, should execute a stored procedure on a database connection. I can't seem to find any information about how this is done. I'm using an ADO.NET Connection Manager to connect to the database and I wish to write my Task in C#. What is the preferred way of executing SQL in a Cu...
We set up SQL server in a cluster. We then used one of the BizTalk servers and installed SSIS on it. We then configured BAM. Everything looked fine until we needed to run some of the SSIS jobs to archive stuff. They don't seem to have been created ... We then tried to change the value in the MsDtsSrvr.ini.xml file and restart the SSIS o...
Within an SSIS package I have a dataflow that extracts two coloumns from an access database a TaskID and a date I store this in a ADO recordset and pass this to a For Each Loop Container I am them attempting to assign each value pair to two variables "taskID" and "taskDate" I then want to use thse two variables within a SQL Insert task...
This is my SSIS excerise I have a DATETIME column, what I want is to get the Month and Year from " DATETIME " column and load it into a new column called “Month_Year” and then get day from the same " DATETIME " and load it into a new column called "day" Visually Source Column: DATETIME Destination Column: Month_Year Day B...
I'm trying to produce a column 'start/length' spec document from a SSIS package that exports a DB table to a flat file. I have hit something of a brick wall in getting the Columns property from the ConnectionManager object that handles the flat file connection. I am able to get the Columns property, but I cannot do anything with it, as...
What is a good,stable and preferably free alternative to SQL Server Integration Services? I'm so tired of this buggy piece of software. ...
Does anyone know of a way to import Google Calendar entries into a database using SSIS. I know I can export Calendars using the ICal format - but there is no native way to parse these files in SSIS. The only way I can think of doing it is to write a script component to parse the file. I'm wondering if anyone has any experience doing s...
I need to call a webservice to validate some data. There is web service task in the control flow but I need to validate during the data flow. Also, the web service supports single or batch validations so it would be nice to batch a 100 items for validation at a time. Is it best to just code all this up in a script component? ...
I want to make a general error handling package that should be called from my other packages when something goes wrong. In this error handling package I want to log what task failed and the reason for the failure. How can I retrieve this information? I'm using the Control Flow Failure precedence constraint to point out a Execute Package...
Hi! I am with my boss and we are having a problem with an SSIS project. Are DataModel sucks and doesn't have a automatic primary key so we have to do the classic and nasty Select Max(id) + 1 from customer The problem is that from the moment that my script task generate the PK to the moment I insert there are 10 rows that has been tu...
I have a SSIS package that writes to a csv file on another server. It will run fine when I execute it manually out of the MSDB folder, but when I try to run it through a job, it fails with the following errors: If I run it with the file path as W:\share\file.csv (I have the other server mapped to the drive letter W:), I get: Execute...
Hi I am tring to import data from excel to sql 2005 .working fine in VS2005,but not working while running from cmd using dtexec. error description as follows "Microsoft JET Database Engine" Hresult : 0x80004005 Description: "The Microsoft Jet database engine could not find the object . Can anyone help how to resolve this issue ...
I am writing a custom PipelineComponent for SSIS, and need to access a connection as defined within the package connection manager. I have tried using the AcquireConnections method as described here but when i call ComponentMetaData.RuntimeConnectionCollection.Count I get 0 (zero) count. Currently my class has the below attribute: ...
I am running a SSIS package to load say a million rows from a flat file, which uses a script task for complex transformations and a SQL Server table destination. I am trying to figure out the best way (well, ANY way at this stage) to write out to a different table the row count (probably in multiples of 1000 to be more efficient) DURING ...
I have a flatfile connection and I'm only interested in the first 10 rows of data. How can I just import the first 10 rows? Row sampling is random so I can't use that. Is there some way I can have some sort of derived column which is an automatic row number or something and then data-split to only keep rows with that id <= 10? Any help ...
Hi I have a script task that is performing transformations in the middle of a SSIS dataflow. If the script fails (say it tries to convert alpha to numeric) I need it to stop with a 'failed' status and return to the main package and then utilise the Dataflow Task Event Handler OnError to exit gracefully. At the moment I find that the sc...
Hello everybody, can anyone help me and tell me how can I run a SSIS package from vb6? ...
Hi folks, I have written an SSIS package that essentially takes data from multiple sources and writes it to an Excel file (it is a bit more complicated than this, but I do not think the specifics really matter at this point). Now, I need to run this DTSX package every week (on a Monday), and every month (on the 1st) and save the excel ...
When I open up the solution that contains SSIS packages created by a colleague, I get this awkward error that tells me nothing about what I'm supposed to do to fix it. He left instructions to take all the "variables" out of the connection string in the dtsx file manually before opening up the solution. I have done that, now when try to ...
Hi All, Is it possible in SQL 2008 (SSIS) to specify multiple file types in the for each loop control? Something like HH*.* and U*.*. That or a cool workaround would be great. Thanks, ...