I am trying to develop a package in SSIS 2005 and part of my开发者_高级运维 process is to check if a file on the network is empty or not. If it is not empty, I need to pass a status of successful, oth
I have recently switched from SQL Server 2008 R2, to SQL Server 2008 SP1.This seems to have caused an issue when I attempt to open an SSIS package in Visual Studio 2008.开发者_如何学运维I get the erro
This is an extension of this question. I have set up a User variable called "Type" and set its data type to Int16.
I have followed the steps mentioned in the below post but w开发者_JS百科ith no success. SSIS Execute a Stored Procedure with the parameters from .CSV file SQL Server 2005
I am attempting to create a custom connection manager for performing SFTP operations from within SSIS. I have completed implementation, strong-named my assembly and installed it in both the GAC and th
I have an SSIS package which is going to be deployed on test, staging, and finally production. It has a couple of \"Send Mail Tasks\",say 10.
Any way to do this since we d开发者_开发技巧efined our fixed width within SSIS, any chance it can spit it out somewhere?I have a project with like 20 different fixed width flat file exports.I\'m not s
I\'m writing an SSIS package to move data from a staging environment to our production server. I have a CLR stored procedure esp_ProcessStagingXML which has 4 parameters, 2 of them output parameters.
In my environment most SSIS packages are stand alone, and only the package it self needs to be deployed to production.
I have a little issue. I need to be able to concatonate the Row1 with Row2 to another/row/table, and the start again on the 3rd row, Join Row3 on Row4 .. and so forth.
加载中,请稍侯......