SSDT Hangs

Question

SSDT Hangs

Adam Sandler

SSCrazy

Points: 2697
More actions
April 6, 2017 at 9:10 am

#322760

I'm setting up a simple file system task to copy a file, I was hoping to use variables to hold
1) File path
2) Filepath and name od exiting file
2) File path and name of file to be created
so for example my file to be created variable is being set in the variables pane as filepath + "Filename.csv"
This process hangs for minutes - tens of minutes. I have treid it on to differant machines - same problem - si there something I am doing wrong?
I haven't even gotten to adding the file system task!
Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246962 More actions · Answer 1

Adam Sandler - Thursday, April 6, 2017 9:10 AM
I'm setting up a simple file system task to copy a file, I was hoping to use variables to hold
1) File path
2) Filepath and name od exiting file
2) File path and name of file to be created
so for example my file to be created variable is being set in the variables pane as filepath + "Filename.csv"
This process hangs for minutes - tens of minutes. I have treid it on to differant machines - same problem - si there something I am doing wrong?
I haven't even gotten to adding the file system task!
Thanks

What is it doing when it hangs?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Adam Sandler SSCrazy Points: 2697 More actions · Answer 2

Well for instance now - ive successfully set up the variables. Trying to drag the task onto the control tab - its hangs = not responding in title bar.

Only seems to have started since I started with setting up expression based variables? Have done lots of packages before on either machine? Thanks

Phil Parkin SSC Guru Points: 246962 More actions · Answer 3

Adam Sandler - Thursday, April 6, 2017 9:28 AM
Well for instance now - ive successfully set up the variables. Trying to drag the task onto the control tab - its hangs = not responding in title bar.
Only seems to have started since I started with setting up expression based variables? Have done lots of packages before on either machine? Thanks

Ah, you mean you're in design mode and it's hanging?
I have no idea then. I use variables with expressions all the time and do not experience problems like this.
What happens to CPU/RAM/Disk while the process is hanging?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Adam Sandler SSCrazy Points: 2697 More actions · Answer 4

Task manager has it at 8 , 35% , 2%
L

in my expression do I set it as @variable to be set = "Value" or just "Value" - it certainly seems to be something to do with my expressions - works ok othewrise?g

Phil Parkin SSC Guru Points: 246962 More actions · Answer 5

Adam Sandler - Thursday, April 6, 2017 10:03 AM
Task manager has it at 8 , 35% , 2%
L
in my expression do I set it as @variable to be set = "Value" or just "Value" - it certainly seems to be something to do with my expressions - works ok othewrise?g

Just value. Here is one I use to get file type, for example:

UPPER(TOKEN( @[User::FullSourceFilePath] , ".", TOKENCOUNT( @[User::FullSourceFilePath] , ".") ))

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Adam Sandler SSCrazy Points: 2697 More actions · Answer 6

Thanks Phil - that seems to have solved it - I had @variable = , whereas I now have just the value , and its working fine now.

Interestingly with @Variable = its still set the value, didnt "error" - just hung for ages! - If you have a spare 30 minutes - give it a go!

Thanks very much for your help - muich appreciated.

Phil Parkin SSC Guru Points: 246962 More actions · Answer 7

Thanks for posting back & glad you got it working.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin