No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky1Votes
Are you a technology guru? Show us your solutions and become the Integration Services Guru for June 2013!!
TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert or authority on SQL Server Integration ...0 Replies | 456 Views | Ed Price - MSFT - Monday, June 03, 2013 6:49 AM -
Sticky40Votes
FAQ - SSIS Information, Webcasts, Tools, Add-ons, etc...
To add to the list, simply contact one of the moderators around here, or post a reply to this thread. Microsoft Reference Material SQL ...38 Replies | 79944 Views | Phil Brammer - Monday, November 26, 2007 5:55 PM | Last Reply Zoltán Horváth - Monday, March 18, 2013 11:08 AM
-
Unanswered0Votes
regarding sql server integration services
Hi, If I have Data Flow task and in that one source and one destination, at the time of execution if ...0 Replies | 2 Views | Koteswararao Bellam - a few seconds ago -
Unanswered0Votes
regarding sql server integration services
Hi, If I have 100 records in source in that 90 are new rows and 10 are existing so how would u update existing rows in destination0 Replies | 7 Views | Koteswararao Bellam - 13 minutes ago -
Unanswered0Votes
regarding sql server integration services
Hi, If I have four tasks (T1, T2, T3, T4), after Successful execution of T1, (T2, T3) should execute and if any one failure of (T2, T3) ...0 Replies | 14 Views | Koteswararao Bellam - 29 minutes ago -
Unanswered3Votes
SSIS job does not run
I have a job scheduling issue and kept getting the “Internal request (from SetJobNextRunDate [reason: schedule will not run again]) to deactivate schedule 15.” message ...8 Replies | 85 Views | BIAnalyst - 10 hours 56 minutes ago | Last Reply BIAnalyst - 4 hours 27 minutes ago -
Unanswered0Votes
How can I change my Execute SQL task setting to behave like SSMS and continue dispite errors
My insert below in ssis produces 26 rows, vs. 86 in ssms. I assume it timesout but I am not sure? I'd like to get the same behavior. I changed MaximumErrorCount to ...11 Replies | 105 Views | intrepid12 - Wednesday, June 19, 2013 9:09 PM | Last Reply intrepid12 - 6 hours 0 minutes ago -
Unanswered0Votes
Multiple simaltaneous update in custom log table from SSIS package.
Hi, I have a custom log table in sql server database. which recording the SSIS package activities(each task execution time, statuses...) when this table is going to use ...2 Replies | 73 Views | Zaim Raza - Thursday, June 20, 2013 2:07 AM | Last Reply Zaim Raza - 7 hours 1 minutes ago -
Unanswered0Votes
SSIS To Oracle Via LDAP Connection
In SSIS, How to connect to Oracle database using LDAP method. Thanks Raj0 Replies | 45 Views | RajkumarShiva - 7 hours 38 minutes ago -
Unanswered0Votes
new to ssis
hi all am new to ssis i created one simple package with lookup table 1 with 2 fields (id and country name) id ...7 Replies | 123 Views | arun sivasamy - Thursday, June 20, 2013 7:30 AM | Last Reply Harry Bal - 8 hours 43 minutes ago -
Proposed0Votes
Deploy SSIS Package with Oracle DB (ADO.NET Connection)
When deploy the SSIS package to windows SSIS Server, the issues found due to the Oracle DB connection thru ADO.NET Connection Manager. The package configuration was created. ...2 Replies | 69 Views | wailun3 - Friday, June 21, 2013 1:37 AM | Last Reply Harry Bal - 8 hours 58 minutes ago -
Proposed0Votes
SSIS DFT Problem
Hello , I am working on SSIS package, environment : BIDS 2008. I am using a data flow task, that contains one excel source component at the ...11 Replies | 241 Views | UdayKGR - Tuesday, June 18, 2013 4:07 AM | Last Reply Harry Bal - 9 hours 6 minutes ago -
Proposed2Votes
Remove duplicate rows
I had a .txt file with 6571 rows and 250 columns The account numbers in the Account_Number column were flawed and I had to fix them using some ...4 Replies | 83 Views | DJ Rele - Thursday, June 20, 2013 9:14 PM | Last Reply Harry Bal - 9 hours 47 minutes ago -
Unanswered0Votes
Error - Integration Services class cannot be found.
Have an ASP.Net application on server that SSIS is not installed, it is calling an IS package from another server which SSIS is intalled. Server that has ASP.Net application is a 64 bit and I ...2 Replies | 73 Views | Angel1953 - Thursday, June 20, 2013 2:33 PM | Last Reply Angel1953 - 10 hours 28 minutes ago -
Proposed0Votes
converting 100 columns
I need to convert 100 columns from dt_str to dt_wstr how can i do this in bulk rather than having to create 100 separate convert expressions.8 Replies | 111 Views | jameslester78 - Thursday, June 20, 2013 5:07 PM | Last Reply Harry Bal - 10 hours 35 minutes ago -
Unanswered0Votes
OLE DB Error when connecting to AS/400, Iseries to call a program
I get the below error when attempting to connect to an AS/400 to call a program: An OLE DB error has occurred. Error code: 0x80040E21. End Error Error: 2009-10-21 ...1 Replies | 5188 Views | Eric_ht - Wednesday, October 21, 2009 1:09 PM | Last Reply ArthurZ - 11 hours 12 minutes ago -
Unanswered0Votes
SSIS Debug Host has stopped working
Well that's the title of the messagebox i'm getting once my package in SQL Server Business Intelligence Development Studio has completed. The package runs successfull on my laptop, but now ...2 Replies | 3321 Views | yannick86 - Friday, November 13, 2009 7:32 AM | Last Reply ArthurZ - 11 hours 13 minutes ago -
Unanswered0Votes
SSIS foreach Loop - creating dynamic log output files and sending email
pointed to pick up *.sql files and then defined a move file system task to move the file to a different folder, to mark it as run. This is running fine. but want to enhance some ...1 Replies | 5094 Views | sql_quest29 - Kin - Wednesday, December 02, 2009 10:37 PM | Last Reply ArthurZ - 11 hours 14 minutes ago -
Unanswered0Votes
Package Path missing from Package Installation Wizard
When I run the Manifest to install my SSIS packages, the Package Path field is missing from the "Specify Target SQL Server" step of the wizard. When a co-worker runs the same Manifest, ...1 Replies | 4397 Views | SQLRocks - Friday, December 04, 2009 4:50 PM | Last Reply ArthurZ - 11 hours 19 minutes ago -
Unanswered0Votes
DependencyAnalyzer
hi I downloaded and installed DependencyAnalyzer.exe, when i ran against SSIS package. if source and target SQL Server, i am getting correct data, if source ...1 Replies | 4855 Views | Vaishu - Friday, December 18, 2009 8:12 PM | Last Reply ArthurZ - 11 hours 21 minutes ago -
Unanswered0Votes
Error when run with a different userid/on different server
This is related to SSIS 2005 There is table which stores connection information. It is fetched correctly and passed on to the connectionstring dynamically to OLEDB connection, in ...1 Replies | 4783 Views | PraR - Thursday, December 24, 2009 1:26 AM | Last Reply ArthurZ - 11 hours 24 minutes ago -
Unanswered0Votes
SSIS Script to Write to Multiple Excel Worksheets, with Different Columns on Each Sheet
I'm trying to extend some of the solutions I've found here and in other SSIS reference websites. I have been successful at writing multiple sheets in a workbook, where each sheet has the same ...2 Replies | 6543 Views | DanR1 - Tuesday, January 05, 2010 10:41 PM | Last Reply ArthurZ - 11 hours 26 minutes ago - Items 1 to 20 of 47334 Next ›