SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• SSIS ForEach FTP: Ability to pass Servername, Username, Password

  I have a SSIS package setup to process a table that contains "group" information. The information …

  leighton_d

  18 replies

  15 years, 1 months ago

  By: cfoulkes

• How to change the "run as" in a SQL Agent Job

  hi guys, i've searched around a bit to no avail, here's my question. i am trying to run an executab…

  manssourianm

  1 replies

  15 years, 1 months ago

  By: Koen Verbeeck

• Find next customer Id and load new data in to destinatino table in SSIS

  Hi, I am working on a task to transfer the source table data into proper destination tables in SSIS…

  radb4u

  2 replies

  15 years, 1 months ago

  By: radb4u

• Convert NULL into "NULL" while exporting data from table to excel.

  Hi All, When I export all the fields from a table to excel (select * from tblname), by defualt it c…

  Joy Smith San

  3 replies

  15 years, 1 months ago

  By: Phil Parkin

• How to migrate SSIS packages from one server to another?

  We have some SSIS packages on one server. We are request to migrate these packages from it to anoth…

  SQL ORACLE

  2 replies

  15 years, 1 months ago

  By: Chrissy321

• Avoiding duplication within the same file

  I have a SSIS package set up which processes about 50 files, each containing anywhere from 4.5MM to…

  TheGreenShepherd

  3 replies

  15 years, 1 months ago

  By: Jack Corbett

• Why a Fuzzy Lookup returns Null set of values from the reference table

  Hi, I am newly learning SSIS for my new task. I have taken a source table (fname, lname, addr1, add…

  radb4u

  1 replies

  15 years, 1 months ago

  By: radb4u

• Unable to programmatically set the value for Microsoft.SqlServer.Dts.Tasks.SendMailTask.SendMailMessageSourceType

  I am writing a VB script for Script Task that will find out if there is any bad/unrecognized data. …

  mhongsyok

  1 replies

  15 years, 1 months ago

  By: COZYROC

• Capturing SSIS Package Validation Connection Manager Errors

  I have a datasource that is unavailable at different times. The datasource is specified in the con…

  gxvanhelden

  1 replies

  15 years, 1 months ago

  By: vijay.msbi

• Problem in Sql Job

  Hi I have an exe which updates the records in table. When I run this exe through package and double…

  kaps.manshani

  8 replies

  15 years, 1 months ago

  By: kaps.manshani

• Migration from Sql Server 2008 sp1 to r2

  Hi, We have a requirement of migrating the Sql Server from sp1 to r2. So, any idea what will be imp…

  kaps.manshani

  5 replies

  15 years, 1 months ago

  By: kaps.manshani

• How to transform table results into another table

  Hi, In a SSIS package, I am getting the output to a table named query. Now, I want to transform …

  Skybvi

  9 replies

  15 years, 1 months ago

  By: Koen Verbeeck

• SSIS 2005 is way too slow. Are there any other ETL good tools?

  SSIS 2005 is way too slow. It took me 30 min to transfer two MS Access tables, each 450,000 rows, t…

  JMI

  9 replies

  15 years, 1 months ago

  By: Evil Kraig F

• FTP Task in Foreach Loop container with expressions

  Hi all Tried to find a similar situation to avoid double posting, but found none. If there is, plea…

  alin.selicean

  8 replies

  15 years, 1 months ago

  By: cpeet

• Add a photo link if the photo exists

  Currently I am builiding a photo link based on some static information and field information, i.e.…

  smac

  1 replies

  15 years, 1 months ago

  By: Phil Parkin