Hi All, Hope you all are doing well. Previously I asked a question how to import a XML file to SQL Server thanks to all you responses. As my source file come with heavy amount of data, I am trying to load by SSIS. Below are the steps I followed: Imported XML by BulkLoad to a XML type column Created XSD Schema out of that XML file in...
The way SSIS generates errors are bit weird. Error detail contains lots of unnecessary data such as "pipeline stopped executing...", "the error is fatal..","The user requested a shutdown..." and on... This is not very user friendly for a end user. So I was wondering on is there any way where we can log/send specific errors only? In my ca...
I know there are ways to automate SQL Server "unit tests." But my question is slightly different. When validating requirements we write a series of SQL Scripts that basically return nothing if success. So basically its like Execute Query Execute another Query Run SSIS Package Run Query. And example with a little more context ...
Hi, I am trying to build a custom SSIS component which combines the functionality of Conditional split transformation and OLEDB Destination Fast Load. in theory, I want to pass a variable to my component and that variable will control my component whether it should run or not according to its value. I am reading http://media.techtarget....
Hi, I am importing a text file into SQL server table which has got number of constraints. I have created one package and associated tasks. At the end of a SSIS package execution, I want to know the erroenous row numbers which were not succefully exported to DB. Is any direct API or variable available in dts namespace to give this inform...
My problem is as follows. I have a CSV file (~100k rows) containting history information with the column format of: ID1,History1,ID2,History2...ID110,History110 Each row may have anywhere between 0 and 110 history entries. Each separate entry requires a stored procedure to be called. If there were a small number of possible entries pe...
I have my SSIS package in server A and I want run a batach process in Server B, Can this be possible in SSIS? thanks ...
How will I create a new/virtual column after pulling data from source before putting into the destination ? which task should I use for creating a new/virtual column ?In my case, I want to create a column of datatype datetime and fill data on that field based on a condition. How is it possible ? ...
I observed that some of my xml files (ssis dtsx packages basically) are getting corrupted randomly. What could be the possible reasons? I couldn't find any clue from system events or logs. Can this be some sort of virus activity? Have you ever faced a similar situation? ...
Using Script Task, I had stored data ie a Dataset or Datatable object to a SSIS variable of data type Object. I wanted to pull data from this SSIS object variable which contains a Dataset object of data, and store it to a destination. This is possible in Script Task itself. I know. But how is this possible by using other SSIS tasks ? We ...
I'm hoping someone can help me, I've explored google to death and I just can't seem to find the answer. I'm new to using SSIS, so I don't know if this is possible...I am exporting data from SQL server database to an Excel file, which works well but it exports all numeric as string. I then have to go in a manually convert it to numbers....
How will we use Connection Manager in Script component, using OLEDB Provider ? I had tried using Connection Manager with OLEDB Provider and SQL, but failed. what is the correct way to use ? ...
I'm currently working on an SSIS package to load mainframe logs from multiple server/file sources into a database. As it stands at the moment I'm using a foreach loop container to loop through a recordset containing filenames and load the files using a Data Flow task from a Flat File Source and File connection to an OLE DB Destination t...
Im trying to merger data together based upon a primary key that will be the same in two record sets. I have the first record set with a primary key and 5 coloums of data and then I have a second record set with the primary key and 5 new colums. I want to be able to merge both record sets together so I can see one primary key and 10 colo...
Has anybody found a way to save an SSIS 2008 package in the older 2005 version? We are running both 2005 and 2008 instances and packages designed under VS 2008 need to be deployed to the 2005 server. Is there a way to do this? Thanks in advance ...
In the SSIS project, I use a custom log provider to write log in script task, like below: Dts.Events.FireInformation(19165, "STBuildFileName", "Attempting to download " + resultantFileName, Nothing, 0, False) But in eventlog, the event id of this log is not 19165 but another one.. Is there anyone know why its behavior like this? ...
How do we use Script Component Transform? And how to call Connection Manager created in Script Component ? ...
When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set. I am using a Native OLE DB\PostgreSQL Native Provider as a connection to the database and other key words are working correctly. I run the query in PGAdminIII and it returns a numeric data type. I re-engin...
I have a very simple SSIS pacakge having 3 containers in the control flow. Each container is explicitly connected by a precedence constraint which evaluation operation is set to constraint only and each has a pre-execute event handler in it. When I run the package from Visual Studio, it works perfect but when I run it from DTExec.exe, it...
I have created a SSIS package in BIDS005 that uses a flat file source as the input. The file I am wanting to use doesnt exist on my local machine, or on the server where the package will be executed. The file exists on a file share on another server, however when I try to use the server path for example: \\servername\fileshare$\filename...