Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
callawayx14
Yak Posting Veteran
73 Posts |
 Posted - 2012-04-27 : 15:52:29
|
| HelloI have a package that copies a template (xls), Runs a sql task and imports the data. On completion a file task runs to copy the populated template, move it and rename it. The problem is....the copied an moved file does not contain the data that was imported. If I look at the original copy of the tample, it contains the data. It's almost like it is copying and moving the file before the import is complete....I'm stuck and apprciate any insight.Thank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-27 : 16:00:16
|
| how have you set the precedence constraints inside package? have you set it in correct sequence?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
callawayx14
Yak Posting Veteran
73 Posts |
Posted - 2012-04-27 : 16:04:37
|
| I believe so yes. I have linked the tasks in the order they should be running. I've also added the value 'Completion' in the constraint itself... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-27 : 16:09:54
|
| ideally it should be on success as on completion will cause successor task to run even if previous task was a failure, which is not what we usually expect in default scenarios------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
callawayx14
Yak Posting Veteran
73 Posts |
Posted - 2012-04-27 : 16:21:08
|
| Thank you. I'v made the change but still recieving the same result. Man!! hahah :) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-27 : 16:22:39
|
quote:
Originally posted by callawayx14
Thank you. I'v made the change but still recieving the same result. Man!! hahah :)
Sorry thats was not solution to your problem but it was best practise tip  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
callawayx14
Yak Posting Veteran
73 Posts |
Posted - 2012-04-27 : 16:23:55
|
| thank you...I appreciate it. I'm new to SSIS... Any help is always appreciated |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-27 : 16:25:33
|
| you saidRuns a sql task and imports the datatry putting a data flow task after sql task to use excel as source and check if you're getting the data. If its not returning anything check query in sql task.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Export/Copy/Move