SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• I have an Excel that has to be imported to SQL Server using SSIS. The file has merged cells which don't seem to import properly. Instead they show up as NULL. Does anyone know how to import an Excel file with merged cells? Thanks.

  .

  atulksharan

  4 replies

  13 years, 9 months ago

  By: Orlando Colamatteo

• How to pass value to Data Flow task's variable

  Hi, How to pass value to variable Of OLEDB Source of data Flow Task. I am using SQL Command As Data…

  avdhut.k

  3 replies

  13 years, 9 months ago

  By: Evil Kraig F

• Duplicate error

  I am trying to insert values from source to destination and i ma getting the following error.What s…

  komal145

  1 replies

  13 years, 9 months ago

  By: n79799

• Adding files of a SSIS package to another SSIS package

  As i told in description i have two SSIS packages P1 and P2. P1 has one DTSX and P2 has three DTSX …

  rahulsony111

  1 replies

  13 years, 9 months ago

  By: n79799

• Data split while loading into CSV

  Hi, I am loading data from sql server to a flatfile (.csv format). One of the column will have valu…

  kishoremania

  3 replies

  13 years, 9 months ago

  By: Phil Parkin

• SSIS using SQl cmd????

  Hi, For creating a SSIS package I am using “SQL Server Business Intelligence Development Studio” th…

  Bhuvnesh

  3 replies

  13 years, 9 months ago

  By: Phil Parkin

• Logging Programatically in SSIS

  Hi I am trying to implement logging in SSIS packages programmatically. The idea is to build the pac…

  n79799

  1 replies

  13 years, 9 months ago

  By: n79799

• Recordset Destination to SQL table?

  Hello - I currently have an SSIS package being built where I want to upload rows from an excel doc…

  david.ostrander

  8 replies

  13 years, 9 months ago

  By: Phil Parkin

• Looking for info on handling error with script.

  I have a package that uses a for-each loop to connect to a list of servers to transfer various piec…

  Stamey

  4 replies

  13 years, 9 months ago

  By: Phil Parkin

• How to execute jobs in parallel from while loop of sql server

  Hi, How to execute a job and loop through it until you have 5 jobs running in parallel(same job n…

  Rajeshpalo

  4 replies

  13 years, 9 months ago

  By: John Mitchell-245523

• multiple datasources/servers?

  Hi, What should be sql server integration package contents? For instance Query is ---------------…

  SQL_path

  4 replies

  13 years, 9 months ago

  By: SQL_path

• Why not processing any records further?

  Hi Friends, I have come up with a weird problem....what i do is very straight forward proc…

  Charmer

  8 replies

  13 years, 9 months ago

  By: Charmer

• file example

  hi, i need example of taking data from file and putting into table and doing some modification of d…

  riya_dave

  1 replies

  13 years, 9 months ago

  By: Ant-Green

• HOW TO READ A ZIP FILE WITH THE SAME NAME FROM MULTIPLE FOLDERS AND UNZIP THEM

  Hi, Iam relatively new to bids.Following is the scenario where i need help. c:\archive has 3 sub fo…

  praveen901

  4 replies

  13 years, 9 months ago

  By: Phil Parkin

• Best Strategy to Create a Million Files using SSIS

  Hi All, We have a requirement to create a file for each unique record from the Database and we have…

  sradez_DBA

  15 replies

  13 years, 9 months ago

  By: GSquared