SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• two source table columns to one destination table

  Hi i have table tab1 with columns a,b,c and table tab2 with columns x,y,z now i have to load the da…

  ahmed7.bi

  6 replies

  15 years ago

  By: Phil Parkin

• Move Multiple Files to Different Destinations

  I am trying to loop through a Source folder (*.txt files) and move all files found to different but…

  Steve Hindle-535638

  17 replies

  15 years ago

  By: Steve Hindle-535638

• Remove the first character of a string

  Hey all, I am running into an issue with a file and I was hoping to get some help. I have a mess of…

  samartel

  13 replies

  15 years ago

  By: Phil Parkin

• SSIS Flat file source varying column and text delimiter issue :crying:

  Hello All, how to handle flat files that have a varying number of columns along with text delimiter…

  Raghav1981

  6 replies

  15 years ago

  By: amitdotchauhan

• copying table with 1 billion rows ..

  Hi, i have a table with 1 billion rows and i need to copy it to my mirror database ( both the sourc…

  badam.manoj

  2 replies

  15 years ago

  By: Phil Parkin

• Remove first two column in excel using Script Task

  Hi, I am converting an Excel File to Flat File [txt file] format. In my excel source file i am get…

  sqlusers

  5 replies

  15 years ago

  By: Phil Parkin

• Read data from an email

  Hey fellow SSIS junkies Good news is that I am really starting to get confident in the abilities to…

  pduplessis-723389

  3 replies

  15 years ago

  By: kkabdul

• Compare two flat files

  Essentially, I'm tasked with performing a SQL task without using SQL Server. Basically, we have an …

  Cadavre

  3 replies

  15 years ago

  By: Cadavre

• SSIS HELP!

  with "Target Field (Address1 varchar(30) & Address2 varchar(30)" My question is " I don't want…

  rocky_498

  7 replies

  15 years ago

  By: rocky_498

• DataFlow: Data comparisons

  Hi, I have a package that is validating some data and I'm not sure how best to go about it. At the …

  sam.dahl

  5 replies

  15 years ago

  By: Evil Kraig F

• Logging question

  Hi all, I just got the logging set up and going for one of my packages. Looks like SSIS automatica…

  stricknyn

  2 replies

  15 years ago

  By: stricknyn

• Custom excel import advice needed

  Hi Guys Attached is a complex spreadsheet that is filled out by boat captains at sea and is emailed…

  DominantDBA

  1 replies

  15 years, 1 months ago

  By: LutzM

• SSIS and SQLAgent problems saving file to mapped drive when run as job

  I have a package saved in msdb which needs to copy a file to a location on another server which is …

  mazzz

  5 replies

  15 years, 1 months ago

  By: Koen Verbeeck

• Error executing SSIS package using xp_cmdshell

  When I am runing my packaGe in Command prompt using the DTEXEC it is executing the pakage when I am…

  preensheen

  9 replies

  15 years, 1 months ago

  By: preensheen

• AlwaysUseDefaultCodePage Property

  Is there a way to set AlwaysUseDefaultCodePage Property to true or false for all the ole db sources…

  sqlstar2011

  1 replies

  15 years, 1 months ago

  By: LSZ