For instance, I have DB A and DB Bb, I would like to set up a data flow task where I take the first ten rows from Table A and programmatically put them in XML format in a string builder. Then, once I
I have got a SQL command like th开发者_Python百科e following : SELECT * FROM temp1 a inner join (SELECT ID from temp2 where ID = ?) b on a.ID = b.ID
I need to reference a column in a component s开发者_如何转开发cript to add it\'s value to a string builder.From there i need to send the string builder to an output column.
In Enterprise Manager 2000 I could create a DTS Package and define a local connection.This made it very easy to use the Pkg across dev, stage, live servers becaus开发者_运维知识库e i did not have to r
We have a complex SSIS job and in each transaction we have to inserts around 30K+ records in SQL server. The package is using the local transactions with trans start and rollback statements. I am bit
I have Excel 2003 files which are imported through SSIS into SQL 2008 R2. With one of the columns I hit a big problem. The column is defined as TEXT in the Excel sheet. Out of 36 rows 32 are having va
We are planning NOT to use MSDTC for transaction managment in SSIS and instead want to use local trsnactions using Begin transaction and commit transaction. From design wise it seems to be OK except o
I\'m working in SSIS in BIDS 2008 and wondering which I s开发者_开发百科hould use as my datasource.This is a 64 bit box running SQL Server 2008Differences that are really important depend on the envir
I a开发者_Python百科m looking online and would like to migrate my DTS Packages to SSIS using migration wizard, but when I go to convert packages it says I must Install DTS Runtime, when I look online,
I a using Microsoft Business Intelligence Development Studio (SSIS) 开发者_JAVA技巧2008. I can see components in my toolbox but they are greyed out. I cannot access them.Have you done a \"show all\" i
加载中,请稍侯......