What are some good learning Resources for SSIS. Some members of our team are going to inherit some SSIS Code and we are looking for some good books, blogs, tutorials, etc. The one thing we are looking for specifically is doing SSIS from a programing point of view vs a DBA point of view. ...
Hi I have a web service that is called from my ssis. Used to work fine in test mode, when moved to live environment I get the error : [Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Objec...
I am trying to change a maintenance plan in SSIS to dynamically backup certain databases to certain places based on certain conditions... But it looks like the maintenance tasks use a collection for the selected databases list. As far as I can tell, I can't seem to manipulate a collection through an expression, nor can I seem to load up...
Hi, I'm trying to use an Execute SQL Task in SSIS 2008 to map a store procedure output parameter to a package variable. The package variable is SSIS type DateTime and the store procedure parameter is SQL type DATETIME. The SQL Statement is EXEC GetCurrentDate @CurrentDate=? and in the parameter mapping screen, the parameter is mapped t...
I have a SSIS 2005 package that is up and running in our production environment. The package uses an SMTP Connection Manager to send an e-mail message out to a designated user. We have a scheduled job that executes this package, and also overrides the SMTP connection string so that the package can target the test or production mail serve...
I am trying to update a field in a table with data from another table, based on a common key. If it were in straight SQL, it would be something like: Update EHSIT set e.IDMSObjID = s.IDMSObjID from EHSIT e, EHSIDMS s where e.SITENUM = s.SITE_CODE However, the two tables are not in the same database, so I'm trying to use SSIS to do th...
I have an SSIS project that contains several SSIS packages. I have a master package that calls the other packages with execute package tasks that references file connections (one for each dtsx file). I am using file connections since this project is still in development and has not been deployed to a sql server. I can run the master pa...
I have an Excel spreadsheet whose first column is mostly numbers or a combination of letters and numbers. These are codes relevant to my business area: 28 38 48 L2 A7 BC etc. The column is formatted as text in Excel. I want to use this as a data source in SSIS for SQL Server, but when I add the object to a Data Flow designer, it forc...
Hi, is there a way to create an inline documentation (like javadocs) for SSIS packages? Or what other techniques do you use to document the things you develop for SQL Server 2005? Cheers, Andreas ...
Argh! I created an SSIS package via an Import Wizard and I can't find the SSIS packages on the server using Management Studio. Execute an SSIS package doesn't appear as an option when I go into job scheduler, either. ...
Does anyone have any advice or techniques for deploying SSIS packages to the Integration services database. Basically I maintain a number of SSIS packages that need to get deployed to several environments (dev, test and production), there is a need to change the individual database connections as well. I would like to automate the proc...
I'm trying to save an excel spreadhseet from SQL Server Integration Services 2005. Unfortunatly I only seem to be able to save in 2003 format but I want to be able to save in 2007 format. Is there wa way to do this? ...
I have a package that imports from a AS400 file to SQL. The package executes properly within Visual Studio, but fails when set up as a scheduled job. the error message is that my password is incorrect. I know that it is correct. I also setup a package configuration and this did not work. I have searched and tried many things. Could someo...
I have an SSIS package named Extract.dtsx. I want to deploy it to the file system in F:\SQL2005\MSSQL\Package\Extract. The Package Instllation Wizard does this simply. I only have to choose "File system deployment" and choose the path, then click next a few times and finish. I'm having trouble figuring out if I can do the same this u...
I have a .dtsx file (an SSIS package) that downloads files from an FTP server and imports data. It runs fine whenever I run it manually. However, when I schedule calling the package as a step in a SQL server agent job, it fails. The step it fails at is the one where I call a .bat file. The error in the job history viewer says this: ...
I know how to create SSIS packages and getting my data source and destinations. But what will i have to do in my package if i want to make it portable in the sense where i can change the source and destination connection strings when i move my package onto another PC? Thanks in advanced! ...
All, I'm trying to import a SQLBase database to SQL Server 2005. I select Import Data. For the data source I select the "Gupta SQLBase OLE DB Provider". Then I fill the properties and press "Test Connection". It replies that the connection succeeded. When I go to the next step I get the following error: TITLE: SQL Server Import and E...
Is there a way to tell Visual Studio 2005 to not rearrange your SSIS package components when you close and re-open the .dtsx? VS2005 always moves my components around in the Control Flow tab and adjusts the flow pointers to seemingly random positions and it gets quite irritating. Anyone know the setting (if any) to stop this? Thanks in ...
I want to use a assembly in a SSIS task. However, it is unsigned and third-party. Therefore, I can't GAC it. What workarounds are available? ...
Hi, I am writing a data comparison code in python to compare the data transformed in the SSIS packages. So, I have all the modules written that accesses the each and every task in SSIS packages. It compares fairly well except for those data that have different datatype, same values but different decimal places. I started out converting...