Integration Services

• Topics

  Started by

  Posts

  Last post

• Which is faster Truncate and Load or Slowly Changing

  Hi I have this problem what among those two ETL choices will i create? I know that Truncate and Loa…

  good_c_ryan_19

  7 replies

  14 years, 6 months ago

  By: rajughy_ghy

• Job Failed due to script task error.

  Hi,I am getting the below error when i schedule to run my ssis package from production. Error:The u…

  sunnyepgc

  4 replies

  14 years, 6 months ago

  By: sunnyepgc

• Which is faster Truncate and Load or Slowly Changing

  Hi I have this problem what among those two choices will i create? I know that Truncate and Load wi…

  good_c_ryan_19

  1 replies

  14 years, 6 months ago

  By: TomThomson

• Assigning result of SQL statement to varible and adding to WHERE clause

  Hi there, I've been looking for a resolution to this all week but can't get it to work, plus I'm ne…

  cidr

  5 replies

  14 years, 6 months ago

  By: rgtft

• How to assign values to the variable in ssis package

  Hi.. i have an ssis package and have created a variable called "Date". now what i want is... exec…

  vinayak.v

  5 replies

  14 years, 6 months ago

  By: Smash125

• I need to update a table from an external file...

  I need to update a table from an external file using SSIS but without loading the file (Excel, flat…

  Mick Opalak

  4 replies

  14 years, 6 months ago

  By: Daniel Bowlin

• Get the count of a result set

  Hi I have a sql task which executes sql commands via a variable and the storing the result set as x…

  kevin4u06

  6 replies

  14 years, 6 months ago

  By: kevin4u06

• script task error

  Hi I wrote the following script to get the standard xml format from the xml variable. the xml vari…

  kevin4u06

  4 replies

  14 years, 6 months ago

  By: kevin4u06

• Finding it impossible to Split a column based on a delimiter

  Hi Everyone I have an input column in an Excel Source, which is of type DT_NTEXT. Inside the data, …

  ashok.theagarajan

  11 replies

  14 years, 6 months ago

  By: MWise

• Advice for dealing with a big SSIS team.

  I have been using SSIS for a few years and I have recently been hired as a Senior ETL Architect. W…

  imani_technology

  1 replies

  14 years, 6 months ago

  By: rgtft

• SSIS Question about network utilization with transfer Objects between servers when package running on third SSIS server

  I have a situation where someone built an SSIS package that is transferring an object from ServerA …

  joverbey

  1 replies

  14 years, 6 months ago

  By: Elliott Whitlow

• Not all records written to SQL table with OLE DB Destination

  I am reading in 6000+ records in a complex query. Then Merge/Joining a couple of columns to the da…

  dlatch

  4 replies

  14 years, 6 months ago

  By: Jack Corbett

• SSIS Configuraton connection breaks down.

  Hello everyone, I came across a issue today related to SSIS that has never seen y me so hopefully s…

  BoobyB

  3 replies

  14 years, 6 months ago

  By: BoobyB

• Data import from excel

  Hi, I am trying to import data from excel to SQL server database (2005). How can I import data from…

  mailmeani_2004

  3 replies

  14 years, 6 months ago

  By: Koen Verbeeck

• read a user variable in the data flow tab

  I have a user var (v_XMLvalue) which contains an xml string. What object can/should I use in the da…

  steve.petruso

  1 replies

  14 years, 6 months ago

  By: Koen Verbeeck