Hi, I've written a simple C# console app that gets executed by SQL Server Integration Services as part of a datawarehouse load (on Windows Server 2003). Unfortunately the step that calls the .exe is failing because a Open File security warning dialog "The Publisher Could Not Be Verified. Are you sure you want to run this software" is ...
I need to use a binary data in a transformation as an integer and do some manipulation, but how to do the casting? I tried many SSIS data types but no luck. By the way I do not want to use script task. [Updated section below] The data is the values stored in the __$update_mask column of the CDC function fn_cdc_get_net_changes. Follow...
I finally got my SSIS package deployed to our SQL 2005 server, and I can run it from my ASP.NET 2.0 code. I needed to change my package after I first set it up. I double-clicked the .manifest file and deployed the package to the same server, but the job is never updated. It stays in the same state as when I first deployed it. Is ther...
I'm trying to create an SSIS package to move data from an Excel spreadsheet into a SQL Server 2005 table. It's mostly going okay, considering that this is the third time I've tried to build a package at all (not what you'd call a flat learning curve). The one thing I'm just not getting through my skull is how to include a package-scope...
This is very straightforward: I have 4 packages, and I would like to define one Error handler for all of them. I already created OnError event handler in one package and now I would like to configure other 3 packages to use the same error handling routine. I don't want to copy and paste. What is the easiest way of doing it? ...
I am trying to have a PostBuildEvent in my SSIS project. This is my original .DTProj file from a test project with one test package. <?xml version="1.0" encoding="utf-8"?> <Project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ProductVersion>10.0.2531.0</ProductVersion> <Sche...
What are the tools available for DTS to SSIS package conversion as part of the SQL servr upgrade and which ones do you recommend?. ...
I've got a data flow task that takes a pair of tables, mashes the relevant data together, and comes out with some results to be put into an indexed table. The indexed table already has data that I'm not getting rid of and for simplicity's sake should retain their existing keys. So, I need to generate a key that starts from the highest Pr...
I'm trying to create a completely new database from an existing MySQL database, bringing over both data and schema, but so far the only way I've been able to do this is to first import the MySQL database into MS Access, and then into SQL Server 2005? Crazy right? Surely, there is a way that doesn't involve a tedious, custom time-consumin...
I have a a project with multiple packages under the SSIS_Packages folder. Can i deploy one of those package instead of the project? The documentation here indicates to use .SSISDeploymentManifest. I don't want to deploy all the packages under the project, just one to SQL Server 2005. ...
I need to upload a file using an FTP task in SQL Server 2005 SSIS. While uploading I am unable to get the folders created on the FTP server. Is there any other solution in SSIS for uploading a file to the FTP server? ...
We are developeing a BI portal and in that most of the data are from SQL Analysis Service OLAP DB. Please let me know which is the method for using the same in web application like ADOMD.NET, OPENROWSET inside existing SP,... Thanks in advance Bipin ...
I am not sure if the "Derived Column" transformation is my solution, but here is my issue. I am importing a CSV file and one of the column has data sorrunded by "'" e.g '2009-01-01' instead of 2009-01-01. Can I use the "Derive Column Transformation" to remove the single quotes? What would the expression be? Solution ~ Used the following...
I am on a 64-bit Windows 2008 server. In SSIS I have an ADO.NET Data Flow Item connected to an ODBC connection. Preview works fine. When I execute in DEBUG mode the following exception is thrown: [ADO NET Source [53]] Error: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no ...
I used to have a dts that had sql server authentication connection. Basically the userid password is stored in the package itself. Now when I go to SSIS the password is not getting stored to the package. I saw this when I google the problem. http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/c720e694-2f58-483a-9c...
I have a job on SQL Server 2005 running a ssis package. The package as the protection level 'EncryptSensitiveWithPassword' the job has only one step of type Operating sytem(CmdExec), since the ssis uses an excel output file and the server is 64bits I do pass the password in the command run as a server proxy The job runs fine when I...
I have a table of customers. This table can be big, millions of rows. Every hour, I have a console app that goes through all the customers and updates another table with customer changes that occured in the last hour. What I want to do is two things: (1) Have the console app (or SSIS package) be multi-threaded so that I can have a coup...
In our environments, sometimes the case changes. Id becomes ID and then morphs into id. When this happens, my SSIS packages (sql server 2008) fail because the column name is not the same case as expected. Here is a way to reproduce the problem. In your Dev SQL Server, create the following tables: DROP Table dbo.CartoonCharacters Go Cr...
Hi, I can't find the following namespace on any of my dev boxes Microsoft.SqlServer.Dts.Runtime; I have Visual Studio Team System 2008 on some machines and Visual Studio 2005 on some. What do I need to install to get this? ...
I created and deployed a package to SQL Server 2005. The package basically downloads a file (.csv) via FTP and extracts the contents to a table. The data is cleaned and then the data is moved to a production table. After deploying the package, I tried calling it from a simple .NET application Dim app As New Application Dim pk...