I have set up a View as the source for a Sql Server Package Configuration that has the same name and columns as the default table.
I have a SSIS package I am trying to schedule. I create a new job under SQL Server Agent. On the Command line tab of the jobstep, I choose \"Edit the command-line manually\".
I am selecting data from a table using FOR XML and outputting it to a file, then need to only FTP the file if the destination directory is empty.
I pretty new SQL Server Integration Server (SSIS) user. Is SSIS able to query data from text files located in another Windows Server? I mean that when SSIS is installed on Windwos Server A, is SSIS ab
Trying to edit an SSIS package, when I go to the advanced editor on 开发者_JS百科the update database package I can only see on the component properties page three properties. ID, Name and Description.
I have a folder where files are going to be dropped for importing into my data warehouse. \\\\server\\share\\loading_area
I am working on a new Datawarehouse trying to import a number of d开发者_JAVA百科ifferent format files from a number of different providers.
what is the use of script component in Data Flow ? Is it same as开发者_如何转开发 Script Task in Control flow ? Any difference ?Comparing the Script Task and the Script Component
I have a Data Flow Task and am connecting to a database via an OLE DB Source component to extract data.This data feeds into a Conditional Split component to separate the data based on a simple express
I currently deployed an SSIS package (Developed on the 2005 version) (developed on my local server) in a pre production environment for testing. I have used the Row count transform to get a count of g
加载中,请稍侯......