Topic profile page for SSIS.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: SSIS.
Topic "Ssis" was discussed 3,901 times on 343 sites in last 3 months
Started 12 hours, 42 minutes ago (2009-11-16 15:24:00)
by richard.hunt
So it automatically updated my package. How do I code on my box with SQL2008 a SSIS to run on SQL2005? I've tried reinstalling the SQL2005 tools to get BIDS on my box but that didn't work. Any Ideas? Thank you Richard Hunt
Started 1 day, 1 hour ago (2009-11-16 03:03:00)
by maevr
> Converted DTS package from sql 2000 to SSIS (2005). When run from BIDS everything is fine but when I try to run a scheduled execution it fails. Have tried soring it in SQL Server and creating a proxy but nothing seems to work. I have read and tested the contents of http://support.microsoft.com/kb/918760 , but nothing works. Any tips?
Started 2 days, 10 hours ago (2009-11-14 17:29:00)
by mgcap
I have code that needs to manipulate Excel using SSIS Script. This code has been running perfectly in DTS for years. I have convered it to SSIS Script - the actual logic is more complex than you see below but I still need to keep it in SSIS script. I now am experiencing that even though the code works, it leaves an Excel process open in task manager. I have debugged this down to what is ...
Started 2 days, 18 hours ago (2009-11-14 09:28:00)
by mgcap
I have code that needs to manipulate Excel using SSIS Script. This code has been running perfectly in DTS for years. I have convered it to SSIS Script - the actual logic is more complex than you see below but I still need to keep it in SSIS script. I now am experiencing that even though the code works, it leaves an Excel process open in...
Started 3 days, 7 hours ago (2009-11-13 20:50:00)
by Ron Ruble
We have a number of SSIS Packages that can fail with bad data from external sources. We handle the bad data without an issue, but after the package logs that an error occurs and it is failing, they often take a VERY long time to end. I'm talking about a package that normally takes 5 minutes, logging a failure, then taking an HOUR to end. This is getting to be a significant problem for us, ...
Started 3 days, 14 hours ago (2009-11-13 13:26:00)
by Ron Ruble
We have a number of SSIS Packages that can fail with bad data from external sources. We handle the bad data without an issue, but after the package logs that an error occurs and it is failing, they often take a VERY long time to end. I'm talking about a package that normally takes 5 minutes, logging a failure, then ...
Started 3 days, 20 hours ago (2009-11-13 07:45:00)
by sudhirBirlapur
Hi everyone. Is it possible in ASP.net 1.1 to execute Sql Server 2005 SSIS package or dtsx package with C#. I say this because the namespace used for this is Microsoft.SqlServer.Dts.Runtime and this is not showing when I'm trying to add new reference in ASP.net 1.1. Please help.
Started 4 days, 15 hours ago (2009-11-12 12:42:00)
by manub22
I've created an SSIS pkg with pulls data from excel source and populate it to a table and vice-versa. I'm able to run the SSIS pkg successfully from BIDS & Integration Services. But when i create a job and run the pkg it gives me following error: Executed as user: JASPER\SYSTEM. able Description: There were errors during task validation. End Error DTExec: The package execution returned ...
Started 5 days, 17 hours ago (2009-11-11 11:02:00)
by jimguy999
Hi, In SSIS, i need to read a flat file (csv) and load into a table in a MSSQL 2005 db. Doing the straight insert was ok. But there are more columns on the target table than the csv file. I am used to using a different ETL tool. In the tool I use, i would create a source or target transformation, and then set a value for the additional columns. What I need to do create is the ...
Started 1 week ago (2009-11-09 17:55:00)
by SundancerKid
I am trying to create a Stored Procedure that the columns can be accessed in SSIS and processed. Here is an example of the code that I am trying to produce: MS SQL 2005 and Visual Studios 2005. CODE CREATE PROCEDURE AIMS_sp_BuildReport04_Barcode_No_Match AS SET NOCOUNT ON CREATE TABLE #blRecs(Barcode varchar(50), Asset_ID varchar(16), Asset_...
Sql server 2008, AS question: Have a cube with 5 partitions Using SSIS to build & deploy cube Each partition represents a day of data. Each day the 'oldest' partition's select query is editted to pick up the latest day (ie. instead of deleting a partition & adding a new one, I change the date in the select statement of the oldest partition to simply look at a new day) If I process/deploy ...
Started 5 days, 19 hours ago (2009-11-11 08:51:00)
by arjun
Hi, Has anyone pulled teradata table into SQL Server 2005 using SSIS. I am using SSIS (Native OLEDB\Oledb Teradata Driver ). and I connect to teredata and pull the data to sql server 2005 tables, this works perfectly in my dev machine. When I publish the package to the server (which has got 32 bit OLEDB teradata driver) my sql agent job fails with the following error: SIS Error Code DTS_E_...
Started 5 days, 3 hours ago (2009-11-12 00:49:00)
by Dave
Does anyone know why my SSIS "derived column transformation" item is truncating hour and minute values from the date type - when inserted in the DB? The code is doing the pretty standard (DT_DBDATE)GETDATE() call with SSIS type "database date [DT_DBDATE]". The DB type is smalldatetime (no seconds stored). I don't think the datetime to smalldatetime conversion is the reason for hour / minute ...
Started 1 week ago (2009-11-09 14:44:00)
by kermitforney
Trying to export from SQL into an Excel spreadsheet, but am getting an ISM error. "[Execute SQL Task] Error: Executing the query "DELETE FROM `ItemForecastingExport$` " failed with the following error: "Deleting data in a linked table is not supported by this ISAM.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or ...
Started 4 days, 8 hours ago (2009-11-12 19:10:00)
by jrpucla
I am using SQL 2005 and NAV 4.0 SP3. I am not a dba so bear with me. I created a new db. I imported the data I needed through SSIS. I don't need all of it and SSIS seemed simpler than dataports. When I go to login to the new db I get an error about the object table and permissions. I don't remember the exact error but I can't get ino the db at all. When I check the new db, there are no users or...
Started 5 days, 22 hours ago (2009-11-11 05:44:00)
by TIMSTAR
Hi I have build a custom connection manager of which is consumed within a number of ssis packages. I have added an additional field/property to the custom connection manager, when I build and release it, it breaks all my existing ssis packages saying there is no property - referring to the one I just added. I can get around this, by adjusting the package meta data and adding the xml, but ...
Started 5 days, 3 hours ago (2009-11-12 00:35:00)
by ewm
I am writing a SSIS package (SQL2005) and need to watch a folder for the appearance of a text file. I am using the WMI Event Watcher task. This WQL code will correctly monitor for any file coming into the folder: SELECT * FROM __InstanceCreationEvent WITHIN 10 WHERE TargetInstance ISA "CIM_DirectoryContainsFile" and TargetInstance.GroupComponent= "Win32_Directory.Name=\"c:\\\\ReceiveQueue\""...
