Integration Services

• Topics

  Started by

  Posts

  Last post

• How to force column explicitly to string type before we export to excel

  I have a package which laods data to excel ,but my manger wants to force column explicitly to strin…

  komal145

  26 replies

  9 years, 5 months ago

  By: Jeff Moden

• Is it possible to upload files to Google Drive from SSIS?

  I have a client request to upload an Excel spreadsheet to Google Drive on a monthly basis, which I …

  Wolfmeister

  3 replies

  9 years, 5 months ago

  By: Wolfmeister

• Global Variables for connection manager

  Hi Sir,Madam, We are trying to implement global variables in SSIS. for example from development to …

  ranala

  1 replies

  9 years, 5 months ago

  By: Phil Parkin

• Foreach File Enumerator loop qith Excel files

  Hi, I have a package that is using a Foreach File Enumerator loop to go through a folder and pull i…

  itmasterw 60042

  4 replies

  9 years, 5 months ago

  By: RonKyle

• Cannot find SSIS package design files to determine datasources, steps, etc...

  I'm reviewing a SQL Server 2008 environment someone (who is not available) designed back in 2006-20…

  ptownbro

  2 replies

  9 years, 5 months ago

  By: ptownbro

• SSIS for SQL 2012 / Script Task Problem with metadata

  Here's the error I'm getting on one SQL 2012 server, that isn't taking place on another SQL 2012 se…

  sgmunson

  4 replies

  9 years, 5 months ago

  By: sgmunson

• Cannot connect to SSIS using SSMS. Access is denied.

  I've just installed SQL Server 2014 Developer Edition and am now trying to connect to SQL Server In…

  ptownbro

  4 replies

  9 years, 5 months ago

  By: ptownbro

• How can i read excel file using column numbers instead of column names

  Hi I have some excel input files but in those files column names text(Header fields) are varying on…

  jahnavi7643

  4 replies

  9 years, 5 months ago

  By: Thom A

• Export Integration Services Catalogs

  Hi Experts, I need to transfer SSIS Packages which are under "Integration Services Catalog" under S…

  SQL_Hunt

  12 replies

  9 years, 5 months ago

  By: Phil Parkin

• ssis and email

  In a sql server 2012 database, I need to run a query and check to see if there is more than 1 recor…

  dianerstein 8713

  3 replies

  9 years, 5 months ago

  By: Thom A

• Storing XML Config files in SSIS

  I am new to SSIS,Need some ideas and thoughts of creating XML configuration (dts config) file (Comm…

  mcfarlandparkway

  7 replies

  9 years, 5 months ago

  By: Phil Parkin

• How to copy entire Solution from one drive to another, rename, and all paths adjust accordingly

  Hello, I have an existing solution that that populates a cube. It's on the local C:\ of the server,…

  quinn.jay

  7 replies

  9 years, 5 months ago

  By: John Rowan

• How to get first day of next month in variable

  Hi All, I have got this (with help from you guys) with how to get the first of the current month: "…

  Kazmerelda

  10 replies

  9 years, 5 months ago

  By: MMartin1

• CoayRoc Table Difference Update and Unchaged Pipeline Flow issue

  Hi, I am facing an issue with CozyRoc Table difference. It is passing Unchanged rows (same in both …

  Re1

  1 replies

  9 years, 5 months ago

  By: Phil Parkin

• Loading Multiple csv or xlsx Files into Table

  I have several dozen csv files where the data quality is poor, so is difficult to load directly int…

  tinausa

  21 replies

  9 years, 5 months ago

  By: tinausa