ssis

相关标签：javascript jquery android 多少钱 iPhone

how do i insert one value into two columns using ssis

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..[详细]

2023-04-12 03:26 分类：问答
making rules in SSIS while importing data to tables from a .csv files

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.[详细]

2023-04-12 03:09 分类：问答
SSIS read/write to variable in script task

I have a variable called Valint that i need to read/write to in a script task, but it doesn\'t seem to work:[详细]

2023-04-12 01:40 分类：问答
SSIS XML Source, no output although using inline xsd schema

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[详细]

2023-04-11 23:42 分类：问答
Making the Input Paramters of web service task dynamic inside SSIS pacakge

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[详细]

2023-04-11 21:33 分类：问答
How do i put where condition using Package variables in SSIS

i have created one ssis package I need run following query Insert intomydata.dbo.MonthEndCDSSpreadCalc(Date,CompanyName)[详细]

2023-04-11 18:55 分类：问答
SSIS how to fail package on parallel step failure?

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开发者[详细]

2023-04-11 17:55 分类：问答
Using a script task in SSIS with C# language, how to convert a DTS ActiveX script that creates files and then appends the full file names

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[详细]

2023-04-11 15:22 分类：问答
How to load data from XML with attribute to database in Sql Server 2005

I was trying to read data of concerned columns from XML given below and load into database. My XML is like below:[详细]

2023-04-11 11:52 分类：问答
SQL SSIS How many Steps is too much

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[详细]

2023-04-11 09:11 分类：问答