No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky1VotesAre 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 ... -
Sticky40VotesFAQ - 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 ...
-
Unanswered0VotesSSIS 2008 Oracle 11g On 64 bit Linux
I am completely new to SSIS. I am sorry if I am stupid with questions I am not able to connect to Oracle Database using connection manager in SSIS 2008. I ... -
Unanswered1Votescall a ssis package
I have a sqlcmd file that is used to load and create a database schemas including tables, view, function etc. At the end of the file, I would like to call to run a SSIS package. ... -
Unanswered0VotesPopulate project level connection manager parameter in SSIS 2012
I have a list of connection string values stored in a table. I want to be able to populate the project level connection string parameter with one of these values from that ... -
Unanswered2VotesValidate URL format in a column - SSIS
Hi, I have a table with 4 columns. One of them contains URLs. Is there a way to validate the URL format in SSIS and have two outputs, one output will have ... -
Unanswered0VotesData Flow Tasks Deadlocking each Other
Hi Experts I am using a SSIS package that does the following task - and Retain Same Connection is Set to TRUE A) Execute SQL Tasks - BEGIN ... -
Answered2VotesDTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
All, I’ve come across an issue with a newly created package. Several error messages are receved relating to the package's connection ... -
Unanswered0VotesMysql to Ms Sql 2005 - Linked Server query select query
I created Linked server in Sql server 2005 and tried Data Migration from MySql to MS Sql 2005 but some of the data got rejetced and i need to find out that which data got ... -
Unanswered0VotesProtocol error in TDS stream
I am trying to import this huge table from a different server and regularly getting this error. I checked online for this error dint get any fix for ... -
Unanswered0VotesFor loop inside For Loop (Nested For Loops)
Hi, I have sequence container, in which there are nested loops. When i execute the container it works fine (it loop thru each year and each Year Month), but when execute the ... -
Unanswered0Votesdata flow task- task not completing (not changing from Yellow to Green)
I am using data flow to get data from a source and loading that into a destination. There are 6k rows in source, after running the job 6k rows gets loaded ... -
Unanswered0VotesRenaming the file with File System Task
The below expression is working fine and I am getting the Date with File name. @[User::SourcePath] + (DT_WSTR, 100) (DT_DBDATE) GETDATE() + SUBSTRING( ... -
Unanswered0VotesNot able to browse to shared network path
> add a network location) but still that drive doesn't appear. I'm using Windows 7. Any ... -
Unanswered0VotesSSIS Match 1 field, append other
So I am going from an Excel file to OLE DB Destination. MY Excel file has a ID_Number and Resolved_Date. I need to look for a matching ID_Number in the destination and if there is a matching number ... -
Unanswered0VotesSQL server linked server error while integrating with odbc driver
Hello We are using MSDASQL (Microsoft oledb provider for odbc drivers) and our own odbc driver to testing below scenarios 1) using Rowsetviewer ... -
Unanswered0Votes/Conn in command line to override config location
dtexec /f "u:..." /Conn {my guid};"my override path" but I keep getting an error basically saying the connectiion "{my guid}" is not found. ... -
Unanswered0VotesMoving files to different folders and adding a date folder at th same time
Hi there, Ive managed to get the following working. I have files with Services within the file names, _SEN_, _EP_ , _FSM_ ... -
Unanswered2Voteserror in package
Hi all, My package giving me this error. Can anyone give me brief insight about this.. " An error occurred while assigning a ... -
Unanswered0VotesTechnical consideration of using SSIS (vs linked server)?
Dear all, It seems to me that it does not make much sense in using SSIS in my case. I think using linked server will take much less time. Today I am shown by using Access, ... -
Unanswered0VotesImport from Excel with Script task in SSIS
Hi! Im trying to learn how to import information from excel with ssis Script task. Could someone help me with the code i ve started with so it works. I get this error ... - Items 1 to 20 of 47316 Next ›


