SSIS data Import from MySql
I am working with SSIS and trying to import data from MySql to SQL Server. I am having issues trying to convert mySql datetimes to SQL Server Datetimes. Any suggestions? ...
ssis
SISS loop through a result set
Hi, I am new to SSIS and SQL. I got a file with below format, need to download images to a folder usng SSIS package. http://content.etilize.com/Large/10077459.jpg Every day this file change. So I need to delete unwanted images from folder as well. Any code will be a greate help. Thanks ...
SQL Server Import and Export Wizard Error
I'm trying to import an 82k+ row table from an access db to SQL Server 2008. Using the SQL Server Import and Export Wizard, I get an error at about 78k records entered. Here's the error: Error 0xc0208265: Data Flow Task 1: Failed to retrieve long data for column "members_notes". Error 0xc020901c: Data Flow Task 1: There was an error...
Sql server Integration Services 2008-2005 compatibility
I recently developed an SSIS package on my dev machine using the 2008 version. Later I foud the customer had Sql server 2005 and doesn't plan to upgrade anytime soon. Is there a way to turn the 2008 package into a SSIS 2005 package, like a downgrade wizard? ...
How do I extract just the date from a SQL datetime value in SSIS?
How do I convert a datetime to just a date in SSIS? I'm trying to perform an aggregate query which will group by a particular date. In order to do that, I'm trying to extract just the date portion of the timestamp(stored as a datetime) so I can perform the GROUP BY on the next step. I've looked at the DATEPART function, but it looks l...
.Net Error(The data area passed to a system call is too small)
Hi Am trying to execute ssis package using dtexec utility from c# app(Creating New Process, assign arguments to Info and finally Process.start(),while processing have come accross "The data area passed to a system call is too small" Error. System.Diagnostics.Process.StartWithShellExecuteEx(ProcessStartInfo startInfo) ** Note:it is fai...
dtexec processstartInfo
Hi What is maximum size of packagevariables for DTEXEC ProcessStartInfo while executing form C#(Process.start()) ...
SQL Server 2005 SSIS Checksum Package
Folks, We're building an ETL process to load mid-size dimensional data warehouse using SQL Server 2005 SSIS on 64bit OS. We're planning to use SSIS's Checksum package to manage SCDs (Slowly Changing Dimensions). Even though we're doing a proof of concept using SSIS Checksum package, I'm not comfortable using it in real production scen...
Update MySQL database from SQL Server in different domain
I am SQL Server developer and the current assignment is little different than what I have done in past. I found Stack Overflow very promising for my problem. I am working on the SQL Server 2005 database for the internal application for my client and the client also got the public facing web application with MySQL database. I do not have ...
SSIS: "Failure inserting into the read-only column <ColumnName>"
I have an Excel source going into an OLE DB destination. I'm inserting data into a view that has an INSTEAD OF trigger that handles all inserts. When I try to execute the package I receive this error: "Failure inserting into the read-only column ColumnName" What can I do to let SSIS know that this view is safe to insert into be...
SSIS Error Logging (Data Flow Compoment Derived Column)
Hello, What the best way to check the column (in DerivedColum component) is NULL. If NULL => log error else continue with data flow. Regards ...
Execute SSIS from Asp.net Application
I am trying to execute a SSIS package from a ASP.NET Application , here is the code that I am trying to use. //DTS Runtime Application Application app = new Application(); //DTS Package Package package = app.LoadPackage(packagePath, null); ...
SSIS: How can I set variables based on data in a text file?
I have a text file with 5 columns and a variable amount of rows. What would be the easiest way to grab the first row of the text file and set 5 different variables in SSIS to the values of the 5 columns in the first row? ...
SSIS Query Parameters for ADO .NET Source
I am trying to retieve data from a MySQL table and insert into a SQL Server table using ADO .NET connections in SQL Server 2008 SSIS. In my data flow task I have an ADO .NET Source which queries the MySQL table (select all invoices) and an ADO .NET Destination which inserts the data in my SQL Server table. Now, I would like to add a para...
looking for a simple but complete sample for SSIS or a tutorial
Hi I'm looking for a complete sample or tutorial (requirements, conditions, how to work...)to start working with SSIS. Indeed, I've installed SQL server 2008 developer edition recently. Thanks for any help ...
Load XML Using SSIS
Hello I have a ETL type requirement for SQL Server 2005. I am new to SSIS but I believe that it will be the right tool for the job. The project is related to a loyalty card reward system. Each month partners in the scheme send one or more XML files detailing the qualiifying transactions from the previous month. Each XML file can contai...
SSIS String or binary data would be truncated. The statement has been terminated.
When I run SSIS package from BIDS it runs fine without any error / problem. When I try to call it through a ASP.NET website I get the following error - "String or binary data would be truncated. The statement has been terminated." I checked all the columns / data to see if anything is exceeding the limit, everything is fine. I can run ...
SSIS XSLT Transform
Hello I am using SSIS on SQL Server 2005, VS 2005 SP2. I have created an XSLT to convert XML to CSV format. When I run this through XML Spy it works fine. I have configured an XML Task within and SSIS package to transform the XML file. Unfortunately, when SSIS performs the transform it does not include the CR/LF at the end of each reco...
SSIS 2008, Excel 2007 formatting excel columns properly (Exporting, not importing)
Hi all, I'm running into some formatting issues with exporting data to an excel 2007 spreadsheet. I have a template file that has the columns formatted correctly, but when the data is exported it doesn't get the correct formats (currency, short date, etc.) I'm thinking I have 2 options Have excel autorun a macro. (hate that idea) Fo...
SSIS 2008 and Excel Interop assemblies
Hi All, Have an SSIS 2008 package that runs just fine on my local dev machine with Office 2007 installed. It has a script task with interop.excel as a reference. (I'm reformatting some excel sheets with it) So everything works like a champ until I install and run it on my test SQL 2008 (Server 2008 64bit) server. I install to SSIS, e...