Hello, I have an error while running a SSIS package: DTS_E_OLEDBERROR. An OLE DB Error has ocurred..... "Could not find stored procedure sys.sp_FuzzyLookupTableMaintenanceInstall" I connect to to my db and I´m able to find the stored procedure. sp_FuzzyLookupTableMaintenanceInstall sys assembly stored procedure 2008-11-24 14:23:08.9...
hi guys, i have successfully run an ssis package and inserted data from one table in the first database to another table in the second database.but all the rows are inserted in this case.i have placed an oledb source control,a character map control and an oledb destination control.no query is written in this.i specified only the source ...
I'm writing a C# application to generate an SSIS package. Part of this involves adding database connection managers - using the library Microsoft.SqlServer.Dts.Runtime. The following line of code shows how this can be done: ConnectionManager cm = pkg.Connections.Add("OLEDB"); In the above code, I am adding an OLEDB connection, which ...
My current client stores all of their configuration information for the enterprise applications in a single table that holds XML. They then use a custom built front end to maintain the configuration values. I'm writing a fairly straight-forward import process for them using SSIS. I need to make the connection strings and some other info...
If I use OnError event handler in my SSIS package, there are variables System::ErrorCode and System::ErrorDescription from which I can get the error information if any things fails while execution. But I cant the find the same for OnTaskFailed event handler, i.e. How to get the ErrorCode and ErrorDescription from the OnTaskFailed event ...
I have a user name and a password that are used in a HTTP Post in a script task that I would like to store as an encrypted value when I check the package into our Source Control system. I would like to see if it is possible to set the ProtectionLevel to EncryptSensitivewithPassword and then mark either a variable that stores the passwor...
I would like to URL encode a URL in a C# SSIS script task. I have tried using System.Web.HttpServerUtility, but intellisense shows it doesn't seem to be aware of "Server". Here's an example of the code that's raising an error: Import System.Web ... ... ... Server.HtmlEncode(TestVariable); I have worked around this issue by writing a...
Hello, I need to migrate data in a large flat table located in SQL Server 2005 into a new SQL Server 2005 schema that consists of a parent table and multiple child tables. This seems like the opposite of a merge or merge join in SSIS but I don't understand how I would go about accomplishing this. Any recommendations are greatly apprec...
I have an SSIS Package with two steps: 1) FTP in to a server and download a file to the local SQL Server 2) Execute a SQL Satatement, that fires a Storeed Procedure. Both of these steps work fine, however, I would like to log the success or failure of these steps, so in the system this is for, add a grid with the status (success or fai...
I have a SSIS package that writes the output to Flat file. Now I need to PGP encrypt the output file and further decrypt in other packages. I am curious if anyone knows of how to do this, or better yet a website with helpful hints on how to do it. Thanks ...
i am working on a SSIS solution for datawarehouse for extracting Surrogate keys of corresponding application keys, I am using look up task of SSIS but the problem with this task is it caches the complete look up table in its memory . And my look up table size is huge i.e. 20 million records. So if u can suggest some ways or alternatives ...
Here is what I am trying to do. I have a perl script that browses a website, fills out a form, and submits the form. This process takes about 1 minute to complete and will initiate an asynchronous process on the website to create a report and drop it to an FTP site. After the form is submitted I would like to kill the process and repo...
I'm a bit of a noob, so pardon me if the answer to this question seems obvious. I have been tasked with the creation of SSIS packages that will operate in an environment maintained by another company. They're using replication to publish updates from client sites to a centralized server, and I'm not entirely certain how they've got it se...
I am using the Send Mail Task in SSIS 2008 to send out an email. I am using SMTP. I have SMTP set up in the IIS manager. I have set it to use windows authentication. The From and To mail address both exist. When i configure the task to send an email, i get an error "[Send Mail Task] Error: An error occurred with the following error ...
All, I have considerable number of SSIS packages, and need to configure it on PRODUCTION environemnt. Just want to know the advantages and disadvantages of configuring and running SSIS packages within SQL Server Agent over File Server. All the packages are designed in SQL Server 2005. Thank you ...
I need to log the Severity of Error in OnErrorCode event handler in SSIS. Severity can be like : Info, Warning, Critical I am just curious if anybody knows about how to get this information to log in EventHandler in SSIS and provide any URL which can be useful in looking for this ? ...
Hi, I've kept my ssis package in my local application folder and through vb.net m able to execute that as package.execute(), But when i publish the same code in my server, its showing some eror, so is that we need to install sql server in the applicaiton server also ? My server does'nt have sql server installed.... or any prerequis...
I have a SSIS package deployed in 64-bit machine. The package is running fine if there are less number of records to be extracted and written to a file. We are using a data flow task for writing into file. However when we are runnning the package for large data extract, the data flow task is not getting completed and the file is getting ...
Hi All, I am new in SSIS development. I know basic SSIS and Can Build-Exceute SSIS Packages Recently I started job where we importing-exporting data from-to text file to sql server 2005 db using SSIS. All my text files are too big with lots of Pharmaceutical record for Patient and Doctor info. I have job to import using ssis, apply ...
I have a few SQL statements stored in text files. How do I pull these files into a string variable in SSIS so that I can use the same query in multiple places? Answer to questions: The queries are long and complex, something I'd prefer to edit in a real text editor, not inside the SSIS text boxes. I'd also like the queries to be edit...