Все вопросы: [ssis]

518 вопросов

2
голосов
1ответов
1846 просмотров

SSIS Data Migration: Split Flat table into Parent + Child/Grandchild tables

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 ...

0
голосов
1ответов
2363 просмотров

SSIS: HTML Encoding a URL in a Script Task

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 ...

4
голосов
4ответов
8588 просмотров

OnTaskFailed event handler in SSIS

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 Err...

0
голосов
2ответов
549 просмотров

Can I retrieve config values for SSIS from XML in a table?

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 ...

1
голосов
1ответов
3209 просмотров

Adding SSIS Connections Programmatically - Oracle Provider for OLE DB

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 cod...

0
голосов
2ответов
942 просмотров

How to update a database table using ssis?

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 t...

0
голосов
1ответов
608 просмотров

sp_FuzzyLookupTableMaintenanceInstall not found while running SSIS package

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 stor...

2
голосов
4ответов
7733 просмотров

SSIS and MySQL - Table Name Delimiter Issue

I am trying to insert rows into a MySQL database from an Access database using SQL Server 2008 SSIS. TITLE: Microsoft SQL Server Management Studio ------------------------------ ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-community-nt]You have an error in your SQL syntax; check the m...

8
голосов
7ответов
21074 просмотров

Using Temp tables in SSIS

I am using a Temporary table in Stored Procedure in SQL Server. I am trying to use that SP in OLE DB Source Editor. I can see the data output returned in the Query Builder that comes with Build Query button. But when I Click the Columns tab, I am getting the below error. - TITLE: Microsoft ...

0
голосов
3ответов
4239 просмотров

How to export tables from sql server to ms access on the fly?

I would like to publish some data of a sql server 2k to msaccess databases. I'd like to do that given a table supplying datatransformation info, for example : tablenameOnServer | pathToPub ------------------------------------------------------ Clients | D:\Data\Pub1\ClientData1....

1
голосов
4ответов
2390 просмотров

SSIS - Importing variable format text files

By "variable format" I mean that each row in the text file begins with a single character code denoting the record type, and each record type has a different format. I believe this is some sort of fairly common mainframe data export method. What makes matters worse is the fact that the record typ...

5
голосов
6ответов
7548 просмотров

What are SSIS packages deployment and change-tracking best practices?

I've got quite a robust development environment regarding my SQL database Schema and Data (everything is source controlled, deployment is automated, etc), but when it comes to SSIS packages, the process is quite tedious and totally manual. How can I automate the SSIS package upgrade process (ri...

0
голосов
1ответов
191 просмотров

Microsoft SSIS 2005. Can't Use Transactions

I have set the package TransactionOption to Required and DataFlowTask's TransactionOption to Supported, but when I execute the package, I get an exception: [ADO NET Destination [82]] Error: The transaction has already been implicitly or explicitly committed or aborted Why does this happen...

2
голосов
3ответов
3642 просмотров

SSIS Package Config File Encryption

We have SSIS package config files that contain DB encryption passwords or PGP encryption passwords. I came to the conclusion that there is no "silver bullet" solution for encrypting SSIS package config files like with web.config files ect. Should we consider not using config files at all for SS...

1
голосов
1ответов
1810 просмотров

Problem validating in SSIS XML Task

I have an XML file that I'm trying to validate against an XSD file in an SSIS XML Task. The XSD does do a handful of imports and includes to other files and utilizes multiple namespaces. I have opened these all in VS2005 and verified that no errors occur when validating the file there. However...

1
голосов
5ответов
1987 просмотров

SSIS Package won't execute when called

I have an 2005 SSIS package that I'm calling in a service created in VS 2005. The package will not run. The purpose of the package is to parse a file and put data into a "Load Table". The package runs perfectly on its own, but will not run at all when executed programatically - when I'm steppin...

2
голосов
2ответов
2372 просмотров

Data Warehousing Postgres

We're considering using SSIS to maintain a PostgreSql data warehouse. I've used it before between SQL Servers with no problems, but am having a lot of difficulty getting it to play nicely with Postgres. I’m using the evaluation version of the OLEDB PGNP data provider (http://www.postgresql.org/ab...

0
голосов
1ответов
3984 просмотров

Using IMEX=1 in SSIS excel 12.0 connection manager causes export to fail

I'm using SSIS VS 2008 to export a bunch of data to an Excel 2007 file. I've used the IMEX=1 option many times in the past to export data to excel 2003 files with great success. For some reason though, this time when I add it to the connection string it falls over at the export step. If I take...

0
голосов
1ответов
2186 просмотров

SSIS: How to read flatfile and add a new row to the file

I have a text file and needs to read it and change some text and add some new text in a new row. How do I add e new row with some text in it? I now use a script component to read existing rows and change in them but I can't add a new row :-( Thanks in advance Regards Brno

0
голосов
2ответов
2000 просмотров

Executing an SSIS DataFlow task with different variable value

I need to query three different database and dump them into csv files. Its the same procedure for the three databases. The only difference is the database and the name of the csv file. Can I do this without cutting and pasting? Is there a way to pass parameters to the data flow task? Thanks!

1
голосов
2ответов
9260 просмотров

Installing Sql Server Integration Services In Visual Studio As Plugin

I ve looked around on Google for a while now without any joy. I have SSIS at work and need it at home - I ve tried installing / uni stalling SQL server with no joy Does anyone have a link to details of how to install? This should be easy!!

3
голосов
3ответов
1388 просмотров

How do I keep a table synchronized with a query in SQL Server - ETL?

I wan't sure how to word this question so I'll try and explain. I have a third-party database on SQL Server 2005. I have another SQL Server 2008, which I want to "publish" some of the data in the third-party database too. This database I shall then use as the back-end for a portal and reporting s...

0
голосов
1ответов
1592 просмотров

SSIS- Sharepoint list data transfer issue

We are trying to transfer data from oracle database (about 60,0000) records only to a sharepoint list using SSIS. But we are getting following error when records reaches around 19000 . The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020 and System.ServiceModel....

0
голосов
3ответов
725 просмотров

Performing a slow update with SSIS

I have a raw file that contains 2m rows ; an ID and a text column What I want to do is use this raw file and update a table on our live database. The problem I have is I want this to happen in batches/slowly as I dont want to impact live too much whilst it is doing this. The process will need ...

0
голосов
1ответов
2609 просмотров

SSIS Packages are not listed in integration services

We have multiple SSIS packages deployed on a production box. All the scheduled jobs that call these packages run fine. Whenever I create a new package and try to deploy, I can see the folder structure and deploy fine. Here is the problem I am facing: When I log into integration services from S...

0
голосов
1ответов
674 просмотров

SSIS - Sharepoint list data transfer

Is there a limit on the number of rows that can be transferred from a Oracle database(OLEDB source) to a sharepoint list using SSIS? I am getting exception after transferring 19000 records

2
голосов
4ответов
6502 просмотров

SSIS For Each File Enumerator multiple file filters

Is it possible in SQL 2008 (SSIS) to specify multiple file filters in the for each loop control? Something like HH*.* and U*.*. That or a cool workaround would be great. Thanks,

10
голосов
9ответов
38697 просмотров

How to fix SSIS : "Value, does not fall within expected range"?

When I open up the solution that contains SSIS packages created by a colleague, I get this awkward error that tells me nothing about what I'm supposed to do to fix it. He left instructions to take all the "variables" out of the connection string in the dtsx file manually before opening up the so...

2
голосов
2ответов
1786 просмотров

Simple SSIS Question - Best Practice: Running same code with different variables

I have written an SSIS package that essentially takes data from multiple sources and writes it to an Excel file (it is a bit more complicated than this, but I do not think the specifics really matter at this point). Now, I need to run this DTSX package every week (on a Monday), and every month (...

1
голосов
2ответов
2633 просмотров

Run SSIS package from VB6

Can anyone tell me how can I run a SSIS package from VB6?