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.
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:
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 g
I\'m trying to create an Integration Service project that will use a set of existing (legacy) databases to create a new database. As I\'m a SSIS noob, my progress is rat开发者_运维知识库her incrementa
I am new to SSIS and SQL. I got a file with below format, need to download images to a folder usng SSIS package.
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
Closed. This question needs to be more focused. It is not currently accepting answers. 开发者_JAVA百科
Folks, We\'re building an ETL process to load mid-size开发者_StackOverflow中文版 dimensional data warehouse using SQL Server 2005 SSIS on 64bit OS. We\'re planning to use SSIS\'s Checksum package to
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
I am working with SSIS and trying to import data from MySql to SQL Server.I am ha开发者_开发问答ving issues trying to convert mySql datetimes to SQL Server Datetimes. Any suggestions?Can you provide a