SISS 2008 - My package goes green very quickly, but does nothing. The connections are opened, but nothing is being passed in the connection.开发者_JS百科
I have a few SQL statements stored in text files. How do I pull these files into a string variable in SSIS so that I can use the same query in multiple places?
I have an application and I want to move some of the tables from the production database to the development database to refresh the data on development.I don\'t need to move all of the tables.
I have a relatively big SSIS package which I\'m trying to edit. I basically need to update a query on an Execute SQL Task. Problem is the solution is not saving the query when I do the change. I open
When would you use Integration Services and when would just use SQL/stored procedures? What are the advantages of using one or the other?
I am calling SSIS package from a .Net windows UI. Both SSIS & .Net app are created in 2008. The SSIS package is stored in file system. When I ran .Net app I got error:
We are importing-exporting data from-to text file to sql server 2005 db using SSIS. All my text files are too big with lots of Pharmaceutical records for Patient and Doctor info.
I have an error while running a SSIS package: DTS_E_OLEDBERROR. An OLE DB Error has ocurred..... \"Could not find stored procedure sys.sp_FuzzyLookupTableMaintenanceInstall\"
I ne开发者_如何学运维ed to log the Severity of Error in OnErrorCode event handler in SSIS. Severity can be like : Info, Warning, Critical
My variable is a string at the package level and have added it as readwritevariable example: public void Main()
加载中,请稍侯......