Lets say I have created an excel connection to an excel file.
During/Before runtime, I have deleted the file.
Is there any way for me to detect if the connection exists or not, and if the connection does not exist, skip a particular data flow process
Check Connection Exist
Hot Topic
- SQL Syntax
- Can't find PInvoke DLL 'sqlceme30.dll'
- Select All column except one in SQL
- Import and Export Data tool bug
- Help! Can I control the recursion times of a recursive CTE?
- how to install sql server 2005
- Set subscriber to other status ?
- Data Mining - Scalar Mining Structure Column Data type error...
- mysql dump(urgent request)
- How to fill Report Header/Footer with data?
SQL Server
- How to check whether Server is Exists with some Table in Particular Database.
- performance comparision of different connection types
- Joining two fields in a query
- SSIS WorkFlow
- Are Tooltips on Report Parameters Possible?
- MDX2005, current day / filter on a member property
- SQL Express and Bulk Insert
- I hate this
- Working with SQL Server 2000 diagrams
- Encrypted Database transfer problem
Check Connection Exist
akramm
You have a couple of options:
1. Use a script task to call out to System.IO.File.Exists to confirm the file exists. This will mean you'll have to get the file name from the connection string or use a variable that the connection manager's connection string uses itself.
2. Use a script task to call AcquireConnection on the connection to see if that succeeds.
Either way, put the result of the check into a variable and use that variable as a condition on the precedence constraint that goes from the script task to the data flow task.
Regards,
ash