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 pac
I\'m looking for a way in SSIS (2005) to create a CSV file from 2 or more different layout OLE DB sources. Again, the column la开发者_开发知识库yout is different for all the sources.
I\'m trying to upload Excel (2003) file into Sql server 2005. At present we are using SSIS to upload the file into a Temporary table (with defined schema) and then moving the data to their intended l
I have a SP that runs a SSIS package. xp_cmdshell \'dtexec /f \"F:\\SSIS Package\\test.dtsx\" /Rep E\'
Hi In my production servers i have only excel 2003 and SQL server 2005 installed I have开发者_如何学Python excel 2007 files to be imported is there a way to do this installing service pack, new driver
I get an \"Class not registered\" error whenever I attempt to connect to the integration services on sql server 2005 from within SQL Managment Studio 2008.开发者_如何学C
I\'m currently building our Data Warehouse, primarily using Ralph Kimball\'s methods and guidance. We are using the Microsoft stack for this (so SSIS, SSAS).
I am developing an SSIS application with VS and SQL Server 2008. I am still new to SSIS, however. I have successfully created one project with an XML Task connected to a Data Flow Task. But as part o
I have an ssis package that imports a view from one database into different db and places the data into a table.The view has all datatypes set to varchar which I cannot change.Some of these varchars a
Is开发者_StackOverflow there a way to stop a SQL Server 2000 DTS (not SSIS) package that is currently running, programmatically using C#?. I think the package can be executed using the COM API, but I
加载中,请稍侯......