i have one excel file and that is containing price column.. now i need to insert that price into table but same price should be inserted into two columns..
i have to import data from a csv file 开发者_JS百科which contains records of users. the problem i face here is to verify that all required field is present.
I have a variable called Valint that i need to read/write to in a script task, but it doesn\'t seem to work:
I have an xml file with some data and inline schema attached to it. If i use it in SSIS (2008 or 2005) xml source component, I get no output to any destination (tried, raw file, flat file, excel, ole
I have a call to a web service task inside of a for loop container in a SSIS 2008 package.I need t开发者_开发百科o pass a date as part of the web service input parameters.The date is calcluated based
i have created one ssis package I need run following query Insert intomydata.dbo.MonthEndCDSSpreadCalc(Date,CompanyName)
Is it possible to stop SSIS package from running with a failure error if one of the parallel tasks in a package fails? Now if parallel task fails other tasks stil execute. Take a look at the pic开发者
I\'m trying to convert a DTS process to SSIS and I want to convert a DTS script task that creates 3 files (only creates the file if there’s data to write to it) and then appends the full file names t
I was trying to read data of concerned columns from XML given below and load into database. My XML is like below:
I have an SSIS package that has 27 steps, ranging from table truncating, 开发者_如何学Cto data importation,transformation, and a bunch of sql queries. My question is, is it better practice to keep the