Hi, my requirement is as follows. the SSIS and DTS packages are stored on the webserver (not in database) and I need to execute them on click of a button on an ASP.NET web page and be able to abort them (again by user action) if they hang for some reason. user doesn't have access to sql server management studio or enterprise manager. if ...
The data from source has string data type and sometime has invalid dates, empty column ('') I want to check whether it is valid date and convert string to date time. How can i do this in SSIS? My string value is already formatted as mm/dd/yyyy. ...
Hi All, How can i send email if execute sql task get executed and loads a table. so, if table is loaded with any record send email, if not loaded no email. Appreciate any help. ...
I have a package that loads data from a text file into a table but I am having trouble setting the package configurations. I was hoping that I could import my package to any database and that that package would automatically lookup the SSISConfigurations table on the database that package is installed on. The package seems to always look...
Hi, I'm programming a custom component for SSIS in which I need the following Enum as a property I can edit (selection of multiple values is needed). [Flags] public enum PermissionSettings : ushort { None = 0, Groups = 1, ADGroups = 2, Users = 4, Owner = 8, OwnerGroup = 16, PublicAccess = 32, System = 6...
As a .NET developer, for what reasons should I prefer SSIS packages over writing code? We have a ton of packages in production where I currently work, and they're a nightmare to both "write" (perhaps draw?) and maintain. Each package looks like a bowl of multicolored spaghetti with C# and VB.NET scripts mixed in at the points where the a...
Hi All, I have an SSIS package that loads data in a table. How do I create a report from that table every time the package would run? NOTE : I asked somebody about this issue and this is what he told me: Create a variable called SSISReport and update that variable in package configuration so every time you have the records in that tab...
We have a SSIS, SSRS and SSAS code repository in VSS that we are moving to Subversion. We have made the sane choice of keeping history in VSS and are making it read-only. I am going to download my entire structure, make it writable, remove all VSS files and VSS info from the Solution and Project files, and then import it into Subversio...
Hey, Out of ideas and about to start pulling my hair out. Maybe someone out there can help: I'm getting the following error when I try to create an SSIS package from C#: Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: No description found ---> System.Runtime.InteropServices.COMException: No description found at Micr...
Hi All, Need Help!!!! I need to load data into sharepoint from Oracle Table using SSIS. Here Table contains Customer Information. I have to create CustomerID as Folder and within the Folder need to load perticular Customer Details How do i buld the Package for this. Note: I follwed the below link, But in that example they are not expl...
The SQL Agent job is returning DTSER_COMPLETION (2) after running an SSIS package. The task of SSIS is completing correctly but is showing many of the following errors: ......Removing this unused output column can increase Data Flow task performance I am not sure whether this can be solved by modifying something in SSIS or the SQL Age...
Anyone aware of guidance on creating a custom SSIS connection manager? I want to abstract the complexities of a source system for the folks that need to extract data out of it using SSIS. ...
I have a table with 63,506 records. After running through a fairly complicated dataflow, the number shown flowing to the SQL Server Destination always matches my initial record count, yet SOMETIMES, not all records are inserted into my destination table. The flow always completes 'successfully', but it's only truly successful maybe half ...
I am trying to update one of my SQL tables with new columns in my source CSV file. These CSV records in this file are already in my SQL table, but they are lacking some of the columns from this CSV file. I already added the new columns to my SQL table. But now I just need to import the data from the new columns. How can I do this b...
I am developing a SSIS package to add data from an XML file to an existing SQL Server table. I have completed several similar projects, but on this XML file I am getting the error from the Data Flow tab between the XML Task and Data Flow Task: Error: 0xC002F304 at XML Task, XML Task: An error occurred with the following error message: ...
I am trying to update one of my SQL tables with new columns in my source CSV file. The CSV records in this file are already in this SQL table, but this SQL table is lacking some of the new columns from this CSV file. I already added the new columns to my SQL table structure via ALTER TABLE. But now I just need to import the data from t...
I have several jobs and several packages. In SQL Server 2005 we used to use DTS Packages, but they are now defunct (I know that I can re-enable them, but that's not what I'm after). I receive the following error by running one of my packages: Message: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeed...
I am developing a SSIS package, trying to update an existing SQL table from a CSV flat file. All of the columns are successfully updating except for one column. If I ignore this column on truncate, my package completes successfully. So I know this is a truncate problem and not error. This column is empty for almost every row. Howeve...
What is the difference between Sequential and Paralle Process Order in Analysis Services Process Task, in SSIS ? ...
Hi, i have two variables in a SSIS package Var1 and Var2. Both of these variables have values. is there any way i can put the values of these two variables in a new table? e.g In New table col1 having value of Var1 and col2 having value of Var2. Thanks ...