i\'m using Sql Server 2008. There are options to run from command line. Is there a wa开发者_如何学编程y to execute an ssis package using sql statement?
could anybody give me any clue why this script not doing the job to write the file? in fact when i\'m trying to run it on SSIS 2005, the task showed up green and success
Till now I\'ve been exporting data INTO the SQL Server CE database, but now in SSIS I\'m attempting to source data that was inserted in a previous step of the import.
I am trying to create a tool that I can upload different types of files \"csv\", Excel, XML and load 开发者_StackOverflow社区those files into a FileStream column in the database as \"Source\" untouche
This question alre开发者_如何学运维ady has answers here: SSIS send email on error sending multiple errors
In SQL Server Integration Servic开发者_StackOverflow社区es 2005, how do I read a directory so I can then process all of the files in that directory?I think you are looking for a foreach loop like this
What 开发者_开发问答is the .database file used for in a SSIS package?Quoting MSDN\'s page on Integration Services Projects
I tried creating a new SSIS package and when I tried Doping a Data Flow Source (say OLEDB Source). I get the error The Component cannot be added to the Data Flow task. With the following Additional in
I am in the pro开发者_JAVA技巧cess of exploring integration between SSIS and IBM MQ Series. Can some point me to some artical for integration. You might be able to use the \"Message Queue Task\" in co
I\'ve deployed a SSIS package to my SQL server. I can run the package fine by connecting to Integration Services in SSMS and right clicking on it and choosing \"Run Package\"
加载中,请稍侯......