Integration Services

• Topics

  Started by

  Posts

  Last post

• Project Deployment Model - Multiple Projects in a Solution

  We've recently upgraded to SQL2014 and we're keen to move over to Project Deployment Model for our …

  Adam McArdle

  10 replies

  7 years, 5 months ago

  By: justin.sherborne

• SSIS decimal conversion working funny

  Hi Experts, We are converting the float value into decimal(38,10) and inserting in a destination te…

  H4K

  5 replies

  7 years, 5 months ago

  By: H4K

• SSIS Dataflow is not throwing any error when there is invalid column in the source flatfile with same datatype

  Please help me asap. SSIS Dataflow is not throwing any error when there is invalid column in the so…

  saptek9

  12 replies

  7 years, 5 months ago

  By: Jeffrey Williams

• Find lines with quoted values

  Hello,I have a job reading a SQL server database that extracts the data into a txt fileHowever, I w…

  joujousagem2006 1602

  1 replies

  7 years, 5 months ago

  By: SGT_squeequal

• Package Validation Error. I cannot run the package any more. After I stopped execution in the middle of tasks in runtime.

  I launched the package. BIDS 2008. Then after the first task executed successfully (the top task in…

  VoldemarG

  4 replies

  7 years, 5 months ago

  By: VoldemarG

• 3 Precedence Constraints point to 1 sequence container (last step in package). But the sequence container is not executed in runtime.

  3 Precedence Constraints point to 1 sequence container (last step in package). But the sequence con…

  VoldemarG

  1 replies

  7 years, 5 months ago

  By: Phil Parkin

• Periodic Snapshot Surrogate Keys

  Hi I am implementing a periodic snapshot for inventory levels. When implementing surrogate keys, sh…

  spin

  1 replies

  7 years, 5 months ago

  By: Phil Parkin

• If the file does not exist continuously

  Hello everyoneI have a system task that attempts to copy files from one directory to another direct…

  joujousagem2006 1602

  2 replies

  7 years, 5 months ago

  By: joujousagem2006 1602

• How can I log the connection strings from an SSIS package execution?

  I'm using the project deployment model with SSIS/SSDT.I've got a number of packages that copy Table…

  Scott In Sydney

  4 replies

  7 years, 5 months ago

  By: Scott In Sydney

• Executing a particular branch of SSIS package depending on value of a variable (1, 2, or 3)

  I have  a package that has Execute SQL task.  SQL Statement assigns a value to a variable…

  VoldemarG

  1 replies

  7 years, 5 months ago

  By: drew.allen

• Error: The type of the value being assigned to variable "User::VARName" differs from the current variable type.

  BIDS 2008.  I need to create a bunch of text files inside ForEach loop in SSIS Package. 1 file…

  VoldemarG

  6 replies

  7 years, 5 months ago

  By: Phil Parkin

• Passing the Next Step Name to a Variable in SSIS

  I am trying to pass the name of the next step to variable the current step.For Example, I want to p…

  ben eiden

  3 replies

  7 years, 5 months ago

  By: Phil Parkin

• SSIS Execute SQL task Error An error occurred while assigning a value to variable

  I am running this statement on execute SQl task  /* drop function if exists */IF object_id(N'm…

  mnr123

  1 replies

  7 years, 5 months ago

  By: Phil Parkin

• ssis 2016 import issue

  In a new ssis 2016 server package, I am trying to update a sql server 2016 table with data from an …

  wendy elizabeth

  1 replies

  7 years, 5 months ago

  By: Phil Parkin

• SSIS package execution fails when trying to load large size Excel file via SSIS Catalog (SSISDB)

  Hello,I was working on a SSIS Package which simply loads an excel file into a SQL table without any…

  pmaceke

  5 replies

  7 years, 5 months ago

  By: Phil Parkin