Viewing 15 posts - 16 through 30 (of 76 total)
99% there. But now when I try to run the package (in visual studio) I get errors in the sscript. When I re-open the script all references to Dts are...
September 24, 2019 at 12:13 am
Here is what I have so far. Just need to say if File.Exists then go to FTP else skip FTP and loop
public void Main()
{
...
September 23, 2019 at 10:27 pm
Thanks, I'm a little rusty on the script task not having used it since the DTS days
Ok I have dragged a script task into my foreach look and set it...
September 23, 2019 at 10:13 pm
Sorry for the wild goose chase (and spam!) I have worked it out.
The error alluded to a path in the database but no corrosponding file on the network so it...
September 20, 2019 at 2:05 am
I've cut out the complication by doing the concatenation in the SQL so now I am dealing with a single variable for the FTP task.
My sql outputs to a resultset...
September 20, 2019 at 12:25 am
Is there a way for me to clear the value of a variable after each iteration?
Clear varible
Populate variable
FTP task using variable
Loop
I can't see a way to set it to ""...
September 19, 2019 at 11:56 pm
Thanks, that' sort of where I'm heading I think but am getting lost in a sea of variables!
I have split the file path into a variable "theSource" and am getting...
September 19, 2019 at 10:25 pm
I see it now thanks. I expected to see it in SSIS rather than SSMS!
June 10, 2019 at 8:38 pm
I see that I can just type in there so I did.
Before A1 (spreadsheet) contained Email, First Name, Last Name....
Now it contains "Email" "First Name" "Last Name"....
What I need is:...
April 12, 2019 at 1:35 am
Unfortunately I only see CR/LF, CR, LF, semicolon, colon, comma, tab, vertical bar
April 12, 2019 at 1:13 am
Thanks, the previous headaches I've had with SSIS have admittedly been between SQL and SQL and problems with the conversion step to get the destination to accept the source string...
April 11, 2019 at 9:53 pm
Thanks. I might be missing something here but we seem to be creating a table and populating it - I don't see how we end up with a physical file....
April 11, 2019 at 8:29 pm
Perfect thanks! I googled openquery syntax to see what was and was not supported by gave up after a couple of pages of fluff.
Is there a way to check for...
April 9, 2019 at 9:54 pm
Works perfectly, thanks! Also doesn't complain when it is passed NULL which is a bonus
April 2, 2019 at 8:44 pm
Thanks, after trying many things I finally got around it by....
Going to the report server, finding the relevant report and selecting 'edit in report builder' from the drop down.
June 13, 2018 at 2:25 pm
Viewing 15 posts - 16 through 30 (of 76 total)