Viewing 15 posts - 46 through 60 (of 541 total)
I have ended up with:
SELECT u.FirstName + ' ' + LastName AS UserName, LoggedInDate, LoggedOutDate,
DATEPART(YEAR, LoggedInDate) AS YearLoggedIn,
DATEPART(YEAR, LoggedOutDate) AS YearLoggedOut,
DATENAME(MONTH,ual.LoggedInDate) AS [MonthIn],
DATENAME(MONTH,ual.LoggedOutDate) AS [MonthOut],
DATEPART(WEEK, LoggedInDate) AS...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
January 28, 2016 at 8:19 am
Thanks for the link I will have a read.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
January 28, 2016 at 7:27 am
It would appear this works.
option batch continue
option confirm off
open my_sftp
lcd C:\SFTP_Get
get *WM.txt -delete
exit
Now to test it as a scheduled task.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
July 9, 2015 at 2:36 am
Hi Ed. I am all up and running with SSIS now but thanks for your input.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
June 29, 2015 at 7:16 am
So the solution for me was to follow this article with the addition of the odd tweak to suit my environment.
http://sqlage.blogspot.co.uk/2015/05/how-to-download-file-from-ftp-site-and.html
I tweaked the following:
SSIS package variable FileName:
I amended value to...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
June 29, 2015 at 5:26 am
I have now implemented a solution. I will post when I find time 🙂
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
June 26, 2015 at 2:00 pm
Thanks for the feedback.
Kind Regards,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
May 11, 2015 at 9:52 am
Old dog, new tricks... 🙂
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 31, 2015 at 7:22 am
Hi Phil. Indeed I can have multiple variables!
I found I had to perform an additional step within the SSIS project. On the FTP Connection Manager I chose Parameterize then created...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 31, 2015 at 7:12 am
Phil one last question. If individual environment variables are created for Server Name / User / Password the subsequent SQL Agent Job appears to be only able to reference a...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 31, 2015 at 4:02 am
Well you learn something new every day. I was having a blonde moment. I have now correctly applied the environment variable.
Many thanks for your input.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 31, 2015 at 3:06 am
Hi Phil. I have attempted your method. I built project then deployed project. I then selected configure 'references' 'Add'. I then selected the environment I created with FTP connection string....
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 31, 2015 at 2:41 am
Hi Phil. I was not prompted for the password. After importing the package into SSIDB I selected configure. I then selected 'Connection Managers'. I selected the connection manager of interest...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 31, 2015 at 2:29 am
Hi Phil.
Are you using the project deployment model, or the package deployment model?
You need to use the former if you want to use environments. If you are not, I recommend...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 30, 2015 at 8:19 am
I now have it working. The resolution.
Flat File Destination > Flat File Connection Manager >
ConnectionString = C:\pathFormat = Ragged right
Expressions = System Variables 'MyVariableName' (for path location)
To run as...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
March 27, 2015 at 6:08 am
Viewing 15 posts - 46 through 60 (of 541 total)