SQL Server 2005 Integration Services

• Topics

  Started by

  Posts

  Last post

• Update a variable in SSIS

  OK, I'm no SSIS expert, but I am trying to do something very simple which I just cant get to work. …

  doug.milostic

  23 replies

  5 years, 1 month ago

  By: Phil Parkin

• ISQueryStoredProcedure Property Can't Change from False to True

  I Can't Change the ISQueryStoredProcedure Property from False to True for it is disabled.:unsure: …

  Welsh Corgi

  7 replies

  5 years, 2 months ago

  By: Liew

• SSIS Error :A buffer failed while allocating 10485184 bytes.

  i have SSIS jobs that was running fine for year and suddenly i am receiving the error as A buffer f…

  jayachandramuni

  3 replies

  5 years, 2 months ago

  By: rohitkocharda

• SSIS: A buffer failed while allocating 10485104 bytes; The system reports 98 percent memory loaded

  I have a SSIS package and it has Fuzzy Lookup with reference table with almost 2 million records(Th…

  hemani2000

  8 replies

  5 years, 2 months ago

  By: rohitkocharda

• Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection.

  I have a package that connects to Oracle and brings data. It also deletes some from Oracle. So when…

  Ali-437314

  6 replies

  5 years, 2 months ago

  By: Rooster

• [Resolved] Isses with upgrading SSIS components (from 2008 to 2014) that programatically generate packages

  Problem: We needed to upgrade SQL Server from 2008 R2 to 2014. In addition to using couple of stat…

  prasad.perini

  6 replies

  5 years, 3 months ago

  By: ajp460

• Issues while executing the xp_cmdshell through SSIS

  Hi All - First let me tell you what my SSIS package does, SSIS Package: - As per the business requi…

  skpanuganti

  13 replies

  5 years, 6 months ago

  By: Jake.ONeill

• Call SSIS package residing on DB Server from a web application ASP.NET residing on Web server

  I have a requirement where I need to call a SSIS package from a ASP.NET application. The SSIS packa…

  vishal.shinde

  14 replies

  5 years, 7 months ago

  By: COZYROC

• SSIS 2016 ROW counts to a Flat File destination

  Hi, I have 3 flat file sources. Now I want to count the number of records in each flat file and I w…

  BIsweet

  6 replies

  5 years, 7 months ago

  By: Phil Parkin

• Error while running SQL Agent job(SSIS) after set value in Set Values tab of package

  Buddies, I created a job with five SSIS packages in SQL Server Agent->Jobs folder. If I run the …

  Kari Suresh

  14 replies

  5 years, 7 months ago

  By: jamestow

• SSIS 2008 - Failed to lock variable Error (Oh, I fixed it)

  I have a package in SSIS that I just created. It contains 2 ForEach loop containers. Within each co…

  Brandie Tarvin

  5 replies

  5 years, 8 months ago

  By: Phil Parkin

• Querying against Access db in SSIS

  Hi All, I'm trying to read the data in Access database using Execute SQL Task. I'm trying to…

  sql server developer

  8 replies

  5 years, 8 months ago

  By: mlinden80

• Determine user SSIS package run as

  I have an SSIS package that is failing. The SSIS package was built in Visual Studio 2005, and is ru…

  Rob

  1 replies

  5 years, 8 months ago

  By: Thom A

• Exporting Multiple SSIS packages from MSDB

  If we need to export a package from MSDB into the file system we can do it using the SQL Management…

  anilkumar0902

  14 replies

  5 years, 9 months ago

  By: Ravi Vissa

• SSIS using source of password-protected Excel Files

  I need to import data from an Excel file into a SQL 2005 DB and thought I would use SSIS since this…

  aber

  13 replies

  5 years, 9 months ago

  By: lilymarthan