Hi, I have a task that to migrate the image type column from sql 2000 to varbinary type in sql 2008. The source column having 3812353 max datalength size for the column. The package always failed with following error message. [OLE DB Source [13177]] Error: Failed to retrieve long data for column "attch_file_content_t". [OLE DB Sourc...
i am using ssis to export from excel to text all export fine except one cloumn have data in this format 0X906111 it but null(nothing) in it when exporting ...
Hi Folks, I have table called Table1 with columns, col1 and col2 with col1 having weblinks for the report and col2 the name of the report. Now, i have a package with a variables var1 and var2 which should get the col1 and col2 values respectively from table1 and send it through an email. if the weblink gets updated in the table, package...
I am using the EzAPI to create a dataflow with FlatFile Source public class EzOleDbToFilePackage : EzSrcDestPackage<EzFlatFileSource, EzFlatFileCM, EzOleDbDestination, EzSqlOleDbCM> Using the example from http://blogs.msdn.com/b/mattm/archive/2008/12/30/ezapi-alternative-package-creation-api.aspx I am trying to use a flat file source....
I am Execute SQL Task on SSIS 2005. ADO.NET connection type and Stored Procedure Input Parameter. Not working. Syntax error I read some documentation and blogs but its not working for me. This is what I have on SQL Statement of the Exeute sql task (ADO.NET) EXEC StoredProcedureName @ParameterName = It gives different errors on d...
Hello There I have created a SSAS project and it works perfectly fine my cubes, data-sources and such first time I deploy the cube, but if I change the data in my database and I click Cube>Process in BIDS it will not reflect the new changes even though when I retrieve the table data in SQL server Management Studio the table shows my da...
Hi, I have spent days trying to solve this problem and still stuck with this and I have posted some questions already on this website, but didn't get satisfactory answers. I am trying to be more clear this time and hope to get a better answer. I have gone through this article already http://blogs.msdn.com/b/michen/archive/2007/03/22/r...
How can a task be reused in SSIS without copy/paste? For example, I'd like to use the tasks I've defined in an event handler for one executable in another executable, but not with all executables in the package. So far, I haven't found any solutions other than writing a complete custom component, which seems like overkill. Any suggestio...
By refering msdn website and other community i was able to run my packages programmatically. I am using a console .net application to run my ssis package. i have hardcorded the location package. it runs smoothly DTSExecResult pkgResults; Application app = new Application(); Package p = app.LoadPackage(@"C:\somelocation"); pkgResults = p...
Hi All, i have a table with two columns and two records as follows. TypeOfReport Links InvalidRecords http://ReportInvalid MissingRecords http://ReportMissing I have a package with execute sql task selecting * from the table above, full result set selected and an object variable c...
The short version is I am looking for a way to prioritize certain tasks in SSIS 2005 control flows. That is I want to be able to set it up so that Task B does not start until Task A has started but Task B does not need to wait for Task A to complete. The goal is to reduce the amount of time where I have idle threads hanging around wait...
I have XML (see below). I need to insert the records in this XML file into a SQL Server 2005 table using SSIS. I'm stuck with the xsd file description. Within Visual Studio when I click the Generate XSD button I get the message "Unable to infer the XSD from the XML file. The XML contains multiple namespaces." Does anyone know of a g...
I have multiple SSIS integration packages logging to a database. They all write to the table sysssislog. I want a stored procedure to be able to return the success of the last run of a selected package. How do I identify a package in sysssislog? The executionid field would seem to work, but it seems like it's changing values on mosts...
SSIS seems to insist on logging to the system table SYSSSISLOG. Is there a way to make it use a different table? I want each package to log to a different table. ...
I'm using SQL Server 2005 to develop an SSIS package. My dataflow contains a SSIS lookup. Each of the rows I'm processing has these columns (among others): ID1, detailsID1, ID2, detailsID2. The value of column detailsID1 should be loaded from a lookup based on ID1, and the value for detailsID1 from another lookup based on ID2. The thing ...
Hi. Given an input of the format (currently a flat file): Name, StartDate, EndDate with sample data like Peter, 2010-09-01, 2010-09-04 I was wondering which SSIS task I could use to split this single row into a row per day: Peter, 2010-09-01 Peter, 2010-09-02 Peter, 2010-09-03 Peter, 2010-09-04 I know I can probably do it with a s...
Hi All, how to use foreach with "for each from variable enumator" if variable is of List<> type in SSIS packages. please give me example thanks in advance. ...
I currently have MS Excel 2.x (BIFF2) files that I receive from a client. They need to be loaded into an ETL system via SSIS. From what I can tell and from my tests, SSIS cannot read these files directly. I have also tried using Aspose.Cells for .NET to open / convert these files in .NET with no luck. Hopefully there is another way t...
I know that in order to edit SSIS packages you need the same version of BIDS or Visual Studio. With Visual Studio 2010 is there any change in the ability to open older SSIS packages or do I need to have VS2005 and VS2008 installed along side my VS2010 installation? TIA J ...
I'm sure that this is a pretty vague question that is difficult to answer but I would be grateful for any general thoughts on the subject. Let me give you a quick background. A decade ago, we used to write data loads reading input flat files from legacy applications and load them into our Datamart. Originally, our load programs were wr...