I need to create a SQL JOB. Step1: Insert a Row into TaskToProcess Table and return ProcessID(PK and Identity)
I have a senario where i have to check the first column of the excel has a valid data and not in the other columns from the CSV file. If the data is not present in the first column my SSIS package sho
I am using SSIS in Visual Studio 2008 with SP1. When I load the designer of an existing package, it always shows an empty area. I have to scroll down and right to see my components or use the area sc
I have a existing DTSX package which I cannot deploy from within the package directory or from a network share.
I have SSIS package that downloading data from table in AS400 server to table in MSSQL, I\'m using IBM AS/400 Client 开发者_如何学编程Access Express driver to access the as400, but data that contains
I have a sql job and a package on server named ssis.I would like to call either that package or that job from a stored procedure on server named storedProcedureServer and return the results of the pac
I have some problem in SSIS package/task setting . I have daily schedule task running via Sql server (SSIS Package).
Text was truncated or one or more characters had no match i开发者_C百科n the target code page. how to avoid this error practically while import data from excelIn general, this could be caused by the f
My company has signed on with Oracle CRM On-Demand, and without debating the merits of the application, I wanted to find out if anyone in the SO community is using SSIS to i开发者_JS百科mport data fro
Newbie to SSIS.I want to read an Excel spreadsheet, ge开发者_Go百科t a value, assign it to a package variable, and then use the variable in a SQL statement.I can read the excel and get the value, cann
加载中,请稍侯......