• How can I structure this in SSIS?

    Within SSIS, I need to do the following: Select the max(to_date) + 1 from a table in SQL Server. Pass this value to a view where clause statement; this view is an Oracle view that needs this date value so I can get the new data from Oracle and load it into this same table in Step 1. How can I do...

    SQL Server Ask the Experts2,585 pointsBadges:
  • VB scripts for SSIS

    Guys, As I'm started to working with SSIS SQL 2005 - SQL 2012 heavily. I'm interested to get more knowledge with how to running and execute VB scripts within a package. I means more how and at what situation should I use vb scripts instead of T-SQL writing. I really need to speed up on this task,...

    Kairizal5 pointsBadges:
  • SQL Export to Excel file column?

    I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

    Shamilh10 pointsBadges:
  • SSIS only 255 rows uploaded?

    Hi, I have a simple Data Flow with an Excel Source and an OLE DB Destination to upload data from an Excel file to an SQL table. The Excel file has 8155 rows. Once the package is finished running, the SQL table only shows 255 rows. The data access mode is Table or view - fast load. Any suggestions?...

    SbcOrc35 pointsBadges:
  • SSIS 2008

    I have a package with 5 data flow tasks and want to run them parallel. If any task fails, should the others still be executed and the task that failed, an email should be sent out.

    shaun20145 pointsBadges:
  • SQL Server 2008 SSIS Update Command Performance Issue

    Hello, In SQL Server 2008 R2, I have created an SSIS package to pull from an ODS and feed a Data Mart. To build the OLAP cube, I am using identity keys as the primary keys to the tables. TableA has 4,000,000 rows and I am updating each row with a foreign key from TableB with 500,000 rows using a...

    Sflatbush60 pointsBadges:
  • SQL server 2008 provide access to SSIS

    Client needs access to SSIS sql server 2008   Thanks, Evgenia

    Evgenia5 pointsBadges:
  • How to Modify SSIS packages created by Copy Database Wizard in SQL Server 2005

    Hello, I recently read Jeremy Kadlec great article titled, "Step-by-Step Guide: Migrating to SQL Server 2005 with Copy Database Wizard". Question for anyone: I used the wizard to copy 12 databases from ServerA to ServerB. However, I now want to set the order of those databases. Unfortunately, I...

    Pjunk5 pointsBadges:
  • How to transfer SSIS Tasks from 2008 R2 to 2012

    I am about to switch from SQL Server 2008 P2 to SQl Server 2012. I use a number of custom SSIS Tasks on 2008 R2 and I’d like to know if it’s possible to transfer them to 2012; and of course if it is possible, how to do it. I tried just opening my DTSX packages in Visual Studio 2010 but they...

    ITKE350,945 pointsBadges:
  • Does SQL Server Data Tools work with SQL Server 2008 (SSIS)?

    I'm trying to figure out if I can use SQL Server Data Tools (that comes with SQL Server 2012) to create SSIS packages for SQL Server 2008. Basically, I just want to use SSDT to create / maintain SSIS on both 2008/2012. Thanks!

    ITKE350,945 pointsBadges:
  • Loading flat file into a database table with SSIS

    Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process: Get file from local or FTP Delete the old file which doesn't exist anymore in the database Insert only new records in the database Automated Don't overheat SQL...

    ITKE350,945 pointsBadges:
  • SSIS on SQL Server 2012

    We're in the middle of upgrading from SQL Server 2005 to SQL Server 2012. However, there's a good amount of SSIS running on this server. Can we re-deploy these packages on the new SQL instance? Will we have to go through Visual Studio upgrade for each? Thanks!

    ITKE350,945 pointsBadges:
  • SSIS, CLR, sp_OAMethod or another method to call web method

    I have a question on which method is the best practice. I have been given a task to run a web service method every 5 minutes. There is one input parameter and no output to return. The service runs a bunch of functions to do data validation and then inserts into a DB2 database. (could not get a...

    ToddN200013,050 pointsBadges:
  • Issue with passing data between two SQL Server databases

    I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server,...

    274703110311274715 pointsBadges:
  • Importing data into SQL server from Intersystem Cache Database

    I have been trying to import data to SQL Server 2012 R2 from Cache database (Inter system Cache). How could I do it? I have tried by using SSIS through which I can export data to Cache? Am I going in the right way? Please help me? Thanks in advance

    nagakrishna5 pointsBadges:
  • connection manager for Sql server 7 database in ssis 2012

    Hi,I created a connection manager to connect to sql server 7 database. After entering user name and password, no databases appear in the list.Does SSIS 2012 support sql server 7?Thanks.

    esch10 pointsBadges:
  • SSIS 2008 R2 Change Configuration File Location

    Starting with SSIS 2008, the /conf option no longer overrides the location of a configuration file. The dtexec documentation states to use the /SET option to override its location. My problem is I can not figure out the syntax to change c:\foo.dtsconfig to d:\foo.dtsconfig.

    Notjust5 pointsBadges:
  • Setup SSIS for a group of developers.

    I newbie and I need help here. We are doing a new MS SQL and BI setup for our developers here. We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that the 12...

    Cnboon5 pointsBadges:
  • The SSIS 2008 R2 job does not complete execution

    I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP's some files to the local folder. I verified to confirm the files are downloaded correctly. 2....

    Iamhere98025 pointsBadges:
  • SSIS 2008 R2 performance and Windows Server 2008 R2 with a clustered SQL instance is slower than when connecting to a non-clustered instance?

    I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a non clustered local SQL instance. It looks like any scenario where SSIS speaks to a clustered SQL...

    RobertDBA5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following