Integration Services

• Topics

  Started by

  Posts

  Last post

• .ods files

  can we transfer data from .ods file to sql using ssis if yes how?

  super48

  1 replies

  11 years, 11 months ago

  By: Eirikur Eiriksson

• Question: How do I pervent Chinese characters from turning into ? (SSIS 2008R2)

  Ok, I've been confronted by this problem during the week where I'm the only guy not on break on our…

  Resender

  10 replies

  11 years, 11 months ago

  By: Resender

• Create a csv file, import data and add filename dynamically

  Help .. I am using SQL Server Data Tools and I am attempting to create a new csv file, import data …

  system243trd

  1 replies

  11 years, 11 months ago

  By: a4apple

• SSIS 2008 package runs SLOW loading to a SQL Server 2012 instance

  I have a package developed with SSIS 2008 on one server. It is loading data from and to separate d…

  mz1derful

  1 replies

  11 years, 11 months ago

  By: a4apple

• Developing packages in Visual studio 2012 to run against a 2008 r2 server.

  Hi, The company I am working for has a 2008r2 server and packages developed using bids 2008. They …

  peter 89731

  7 replies

  11 years, 11 months ago

  By: Lynn Pettis

• importing to SQL Server from .txt

  Using SSIS, I'm importing a .csv flat file source having 7 columns into a SQL Server table destinat…

  KoldCoffee

  18 replies

  11 years, 11 months ago

  By: Lynn Pettis

• Data transfer for large number of Rows poor performance of package

  Hello, Below is my query which i am implementing in SSIS. My data transfer is from different server…

  Megha P

  4 replies

  11 years, 11 months ago

  By: SQLCJ

• data transfer with SSIS multiple left join with source table

  Hi, below is the query i am implementing in SSIS .Below records should be inserted in destination t…

  Megha P

  11 replies

  11 years, 11 months ago

  By: Megha P

• CSV file to table

  I'm wondering if the data from a sample csv file can be transformed and loaded into a table. I hav…

  rs80

  13 replies

  11 years, 11 months ago

  By: Jeff Moden

• Offline-Jobs schedule

  I have scheduled my jobs successfully and they run fine in SQL Server Agent 2008. But When I shutdo…

  ssis2008r2

  4 replies

  11 years, 11 months ago

  By: Phil Parkin

• Query from Source not sure how to get into Destination

  I am using SSIS 2012 and am pulling from a Server in cloud that I have read only rights to. after I…

  jameslauf

  2 replies

  11 years, 11 months ago

  By: Phil Parkin

• Move file system task errors out on the last file

  I have been developing a package which moves excel files from staging folder to archive folder, onc…

  rockstar283

  1 replies

  11 years, 11 months ago

  By: rockstar283

• Flat file quote as a firstr character suddenly a problem

  Ok I got the following issue: SSIS to import flat files,everything went fine for months,now suddenl…

  Resender

  6 replies

  11 years, 11 months ago

  By: Koen Verbeeck

• How to Check whether the filename is todays file or not(filename like CLM_2014050).

  Hi All, I have file name like this CLM_20140504.I will get file everyday..I just need to …

  naresh0407

  3 replies

  11 years, 11 months ago

  By: Eirikur Eiriksson

• Diiference between XML and Sqlserver package configuration

  Hi All, Could you please tell me the difference between Xml and Sqlserver package configurat…

  naresh0407

  1 replies

  11 years, 11 months ago

  By: Phil Parkin