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

    ITKE435,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!

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

    ITKE435,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!

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

    ToddN200054,455 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:
  • MaximumErrorCount

    HOW DO I CHANGE THE MaximumErrorCount IN SSIS

    Vercom5 pointsBadges:
  • SSIS cache

    We are developing packages in a SSIS environment using Version 9.00.3042.00. I’m presently having problems or a misunderstanding on when to use Partial or Full cache on lookups. Seems like the lookup results differ when using these two modes. For example, full lookups often “succeed” (turn...

    Kurt5 pointsBadges:
  • Refresh Excel file on a different server with SSIS package

    I am trying to refresh an excel file that is on different server. is there any script that can be creatted with SSIS pacage that can do this. any help will be appriciated. Thank you in advance.

    Tocken10 pointsBadges:
  • Write Record to table as XML from RecordSet destination

    Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?

    Kayj5 pointsBadges:
  • Without Using Script in SSIS

    HI!!! how do I alter data in SQL Server table [select, insert and delete] using SSIS Visual Studio without using a T-SQL Script... please help me T_T.... Thx so much... :D

    SSISCaseStudy5 pointsBadges:
  • Tool for ETL/SSIS packages testing

    Which is the Best Tools for ETL/SSIS packages testing

    Contactvishal5 pointsBadges:
  • Problem with SSIS & AS400, Source is AS400, Dest is SQL2005

    When I'm trying to retrieve data from AS400, I received the below error: The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". How do I know which code page to use besides the default of 1252?

    Thuybui35 pointsBadges:
  • Migrating DTS packages that use mainframes source to SSIS

    I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?

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

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

Following