SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Create table from file and then load the data

  Hi, is there a way via SSIS to create a table to match a file's headers (which can change), and the…

  g_demetriou

  3 replies

  11 years, 8 months ago

  By: g_demetriou

• File Archive Question in SSIS

  Hi guys, Here is my question, I have to archive every day file. I know I can use File System Task …

  rocky_498

  2 replies

  11 years, 8 months ago

  By: Raunak Jhawar

• Connect SSIS 2005 to teradata

  i want to connect to teradata using SSIS 2005. i have .net drivers for teradata. i'm able to to add…

  rashmi_mehta

  2 replies

  11 years, 8 months ago

  By: Janie.Carlisle

• how to create ssis package to copy table from one server to another server

  how to create ssis package to copy table from one server to another server using BIDS

  rhythm.varshney

  6 replies

  11 years, 8 months ago

  By: lmacdonald

• SSIS and EXEC sp_makewebtask

  I have an SSIS package which extracts N number of text extracts for each distinct value in col1.The…

  mtz676

  1 replies

  11 years, 8 months ago

  By: Sean Pearce

• Version error when trying to edit SSIS package

  I recently upgraded my SSMS 2008 to 2008 R2 to allow me to view SSIS packages through Integration S…

  best1

  6 replies

  11 years, 8 months ago

  By: best1

• Removing noisi commas in CSV file (SSIS)

  I am quite new on using SSIS dtsx on SQL server 2005. I have CSV files that have been cleansed remo…

  damien.gulluni

  17 replies

  11 years, 8 months ago

  By: damien.gulluni

• Need Help

  Hi , I am trying to delete files in a folder except the last created file in the folder. can you pl…

  sql2k8

  1 replies

  11 years, 8 months ago

  By: Cadavre

• Pass Variable to Precendant Constraint

  This should be really straight forward and easy, but SSIS variables are not easy for whatever reaso…

  Jody Claggett-376930

  11 replies

  11 years, 9 months ago

  By: Dennis Post

• Importing data from DB2 to Sql Server 2005

  dear all, plz i need your help , i want to import data from DB2 to Sql server 2005. i was trying it…

  abr_mah

  2 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• Export large amount of data from one table to another

  Hi Guys, Is there a way to start up an export from one table to another, if the data export fails a…

  Imke Cronje

  4 replies

  11 years, 9 months ago

  By: herladygeekedness

• Send mail with resultset using script task

  Using Script task i have to send data records. I am aware of send mail via script, need help on pas…

  Shanmuga Raj

  1 replies

  11 years, 9 months ago

  By: herladygeekedness

• same issue

  i have the Same issue. Please provide solution thanks in advance.

  patelchintan.us

  3 replies

  11 years, 9 months ago

  By: herladygeekedness

• Higher level edition required?

  Hi, When deploying a package with an ftp task to my server I get the above error although it runs f…

  Alexander G.

  11 replies

  11 years, 9 months ago

  By: sboubin

• Creating tables on the fly with SSIS

  I wanted to create a set of tables on the fly using a SQL script can I do this via an Execute SQL t…

  tripower

  14 replies

  11 years, 9 months ago

  By: Phil Parkin