Integration Services

• Topics

  Started by

  Posts

  Last post

• Script Component for vbCrLf -> vbLf EXCEPT for row delimiter

  I have the following script. It converts any CRLFs in the flat file to LFs. I only want this to h…

  ZenDada

  1 replies

  14 years, 5 months ago

  By: SpringTownDBA

• Is it possible to dynamically create tables in the destination database?

  Hi, We have a Sybase database which contains 138 tables and I would like to copy these including da…

  Shabba

  2 replies

  14 years, 5 months ago

  By: Shabba

• variables type issue in execute SQL task

  Variables on package level are User::EntryNo, type is Int32, value is 0 User::CompanyCode is Strin…

  battery_acid_h

  2 replies

  14 years, 5 months ago

  By: battery_acid_h

• Flat File Source - only 500 records?

  Hi I have a comma delimited flat file of 1000 records (the delimiter is /&^$%@ as the columns…

  Cowboy DBA

  4 replies

  14 years, 5 months ago

  By: Cowboy DBA

• normalizing SQL configurations (and a "hopeful" regarding denali)

  Assume I have 3 SQL servers in my environment which may be used as part of a source or destination …

  Don Halloran

  4 replies

  14 years, 5 months ago

  By: Don Halloran

• find an object in ssis

  I have many data flow tasks in one of my ssis packages. Is there a way to search in the control flo…

  sqlfriend

  1 replies

  14 years, 5 months ago

  By: Elliott Whitlow

• Error connecting to Integration Services

  I am trying to use SSMS to connect to an Integration Services server. We have only one domain and …

  imani_technology

  3 replies

  14 years, 5 months ago

  By: Elliott Whitlow

• SSIS how to update while migrating?

  hi there, i have two tables MASTER AND CHILD MASTER has the following columns master_id, master_nam…

  winseelan

  9 replies

  14 years, 5 months ago

  By: rgtft

• Data Flow failing when package run as a job.

  Okay, I need to move advantage database files from the adavantage server to SQL Server. Old way - …

  jwbart06

  4 replies

  14 years, 5 months ago

  By: jwbart06

• Null Values doesn't Show up in Excel Destination file

  Hi , I have a situation in which , i need to transfer the sql data into Excel File. So I use the OL…

  hardial_bhatia

  3 replies

  14 years, 5 months ago

  By: GSquared

• Add Datetime Stamp to the excel Destination File

  Hi all, I want to add datetimestamp to my excel file name Filename: Nuetraltables_disposition.xls E…

  hardial_bhatia

  2 replies

  14 years, 5 months ago

  By: hardial_bhatia

• How to access File attributes from within SSIS package?

  Hi All, I have an SSIS package where I copy a template and write to the copied file. All has been g…

  TK-487581

  4 replies

  14 years, 5 months ago

  By: lijnenjoost

• Attunity works from BIDS (Standad Edition)?

  Hi, I have used this Attunity client in Staging environment, which has Enterprise evaluation versio…

  naresh.elugala

  11 replies

  14 years, 5 months ago

  By: prvmine

• SSIS Script Component - Error:

  Hi folks, In the script Component in the data flow task, i am getting a System.NullReferenceExcepti…

  Ramdas Narayanan

  4 replies

  14 years, 5 months ago

  By: Ramdas Narayanan

• ADO Source using a SQL Command to pull data from SQL Server(2008) in SSIS(2008)

  Hello, I'm using an ADO Source to read a sql table with inline sql. I developed the sql code in Man…

  steve.petruso

  2 replies

  14 years, 5 months ago

  By: steve.petruso