SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Bulk Insert Task: An error occurred with the following error message: "Cannot bulk load because the file "\\servername\Data Files\Narrative_2006.txt" could not be opened. Operating system error code 5(Access is denied.).

  I am developing an SSIS package that I am currently just running from BIDS that takes a file from …

  Sherri Barkley

  2 replies

  15 years, 5 months ago

  By: Sherri Barkley

• Using if else condition in SSIS

  Hello, I need to implement the following functionality in SSIS- If the value for a column(POL_COUNT…

  pwalter83

  3 replies

  15 years, 5 months ago

  By: steveb.

• File Path Not Found

  Hi - quick help please - the help desk is clueless. A server that runs close to perfectly all the t…

  Janie.Carlisle

  3 replies

  15 years, 5 months ago

  By: Janie.Carlisle

• How to Unzip the file Using script task

  Hi iam using script task to unzip the file.I am not good at vb.net. Can you help me in writing the …

  dheer

  17 replies

  15 years, 5 months ago

  By: lijnenjoost

• How to decided which connection type to use?

  New to SSIS. Will someone kindly tell me what questions I need to ask about the data sources in ord…

  KoldCoffee

  14 replies

  15 years, 5 months ago

  By: KoldCoffee

• Flat File Import in SQL Server 2005

  I am trying to import the following file My\flat\file\delimited by\backslash to come in as My …

  pt9s

  7 replies

  15 years, 5 months ago

  By: Koen Verbeeck

• Visual Studio for Apps environment does not launch

  I have a Script Task in the control flow and when I edit and click Design Script, the Vis.Studio fo…

  btio_3000

  4 replies

  15 years, 5 months ago

  By: Koen Verbeeck

• mapping excel data types to SQL Server

  SSIS 2008 is assigning a "date" data type for several columns in the source excel file and mapping …

  KoldCoffee

  2 replies

  15 years, 6 months ago

  By: Phil Parkin

• Using Integration Services without GUI?

  I dislike Integration Services. Maybe it is just the fact I am a programmer, but the product appea…

  johnzabroski

  18 replies

  15 years, 6 months ago

  By: Koen Verbeeck

• Edit SSIS package that is connected to Server

  I need to Edit a SSIS package that is connected to the server and is scheduled to run everday night…

  Minnesota - Viking

  2 replies

  15 years, 6 months ago

  By: Jeffrey Williams

• SSIS Configuration and Deployment Issue

  Hello all, This is the weirdest thing that I just can't seem to figure out. I have a package which…

  stricknyn

  3 replies

  15 years, 6 months ago

  By: Koen Verbeeck

• Conditional Split

  Hi I have created the table with EmailAddress column in SQL Server 2008 DataBase Now I need to writ…

  dnyanesh.09

  10 replies

  15 years, 6 months ago

  By: Koen Verbeeck

• windows scheduler to run the package

  I am trying to schedule a ssis package thru windows scheduler; can someone let me know how to do it…

  keywestfl9

  4 replies

  15 years, 6 months ago

  By: John Mitchell-245523

• Taking Database backup for every 4 hrs in SSIS

  hi.. i'm trying to retrieve the data from database using ssis package.. database name is employee w…

  vinayak.v

  4 replies

  15 years, 6 months ago

  By: vinayak.v

• Append multiple file names

  I have multiple files that contain data from a soon to be extinct application. Each file is named …

  Erin.

  1 replies

  15 years, 6 months ago

  By: Koen Verbeeck