SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Variables in Execute SQL task

  Should be simple: I have a pkg variable, @lclValOn, that determines whether or not validation is en…

  herladygeekedness

  6 replies

  14 years, 11 months ago

  By: herladygeekedness

• Error while Transfering of Excel data to MSAccessDB

  Hi , i am trying to transfer data from Excel to Access DB, i am receiving the following errors 1. …

  veen_computers

  1 replies

  14 years, 11 months ago

  By: herladygeekedness

• Connection string automatically changes when i save the packge

  Hi every one, I have an issue with my SSIS package. I have a ssis package which is running fine on …

  sqlnew

  3 replies

  14 years, 11 months ago

  By: herladygeekedness

• CTE woe/weirdness with OLD DB Source

  I've created a view which uses a CTE to partition on CentreID and order by AddressID. In essence I …

  Cowboy DBA

  1 replies

  14 years, 11 months ago

  By: Koen Verbeeck

• Split Column

  Hi guys, Here is my data Add,Street_Number,Street_Name 123 Johnson St,Null,Null 22 Main Blvd, Null…

  rocky_498

  5 replies

  14 years, 11 months ago

  By: Jeff Moden

• Lookup transformation not finding value in table.

  I have a lookup which is looking in a table for a column that is a char(4) datatype. If its not fou…

  dndaughtery

  1 replies

  14 years, 11 months ago

  By: dndaughtery

• Are SQL Temp Tables OR Table Variables Supported to use with SSIS variables?

  Hi, I posted a similar question in another forum but received no responses. Possibly because no one…

  mindscape777

  2 replies

  14 years, 11 months ago

  By: Charles Hearn

• If exporting data to excel exceeds 65536 rows.....

  Hi Everybody, Recently I've started to do an assignment with excel workbook. Here am facing an crit…

  Janaa

  8 replies

  14 years, 11 months ago

  By: Eric M Russell

• sourcing from a remote FoxPro free table directory?

  I'm tasked with bringing data in from a remote FoxPro database to SQL 2005. It's a "free table" (n…

  Greg J

  2 replies

  14 years, 11 months ago

  By: Greg J

• dtexec /L Logging to Text file is not working

  I am looking to promote a SSIS package to various servers. The name and location of the text Log F…

  David Bird

  2 replies

  14 years, 11 months ago

  By: Jolene Yuan

• New to this how do I....

  Hi, I have created a new Dataset and I want to use the primary key from that dataset to delete fro…

  Edward-445599

  6 replies

  14 years, 11 months ago

  By: steveb.

• Executing SSIS in SQL as a job reports successful but nothing happens

  So I have a very simple package I have created, all it does is look in a folder for any csv files a…

  dave 92282

  2 replies

  14 years, 11 months ago

  By: dave 92282

• Kimball SCD implementation

  Hi Team, I am very new to the SSIS..... Problem Statement: Source table has 2 Million records (firs…

  JoyKing

  3 replies

  14 years, 11 months ago

  By: Koen Verbeeck

• Reg. SQL Server job

  Hi i am using sql server 2008. In sql server 2008 i have scheduled 5 jobs in all different times. i…

  systems.blr

  2 replies

  14 years, 11 months ago

  By: Elliott Whitlow

• Need Help to create SSIS package to insert data from muliple Tables into 1 tables in SQL Server 2005

  Hi Experts, I need to create an SSIS Package to insert data from more than one table to one table. …

  alokjain_mca

  4 replies

  14 years, 11 months ago

  By: SinisterPenguin