Viewing 15 posts - 7,006 through 7,020 (of 13,876 total)
itortu (6/23/2016)
VB6
[code-"sql"]
IIF([Type]...
June 23, 2016 at 11:16 am
rocky_498 (6/23/2016)
Awesome Phil, It WORKS!Thank You.
Great, well done!
June 23, 2016 at 8:33 am
tindog (6/23/2016)
HappyGeek (6/23/2016)
Spam on the rise again, really not interested in solid wood furniture!Not even at low low prices?
I wonder if that anti-aging serum works on old farts like me....
June 23, 2016 at 6:44 am
rocky_498 (6/22/2016)
I need help.
Here is my sample data
ID,FNAME,STATE,AGE
1,JIM,CA,12
2,CARLOS,NY,14
3,JENA,CA,15
4,TIM,GA,12
What I want, I want to create an SSIS Package, where I can create a .csv file from the above data....
June 22, 2016 at 6:07 pm
komal145 (6/22/2016)
yes sir, i tried. I still run into errors. i have Google analytics SSIS source in my packge. It is not even recognised by VS.
As the 'Google Analytics source'...
June 22, 2016 at 2:16 pm
komal145 (6/22/2016)
I get so many errors when I copy.isapc file from VS 2012 ssis project and upload existing package to VS2013. Not recognizing...
June 22, 2016 at 12:06 pm
jasona.work (6/22/2016)
June 22, 2016 at 6:23 am
Something like this?
select UserID , Identifier , FirstName , LastName , Phone, getdate() 'DateOne', SUSER_SNAME() 'UserNames'
into TempTable.dbo.Evalthree --IN 'TempTable.mdf'
from TempTable.dbo.EvalOne
But I can't see why you would bother doing this!...
June 21, 2016 at 6:02 pm
OK, that helps. Here is a generalised form of your command, showing what you need to do. Obviously, you need to replace SourceDb and TargetDb with your source and target...
June 21, 2016 at 5:32 pm
This construction is wrong:
select
[UserID] ,[Identifier] ,[FirstName],[LastName] ,[Phone], DateOne, UserNames
into TempTable.dbo.EvalTwo --IN 'TempTable.mdf'
select
[UserID] ,[Identifier] ,[FirstName],[LastName] ,[Phone],
(select getdate()) as DateOne, (select SUSER_SNAME()) as UserNames
from
into TempTable1.dbo.EvalOne
Please describe what you are...
June 21, 2016 at 4:11 pm
Are your databases really called TempTable and TempTable1?
June 21, 2016 at 4:08 pm
Andy Leonard (6/21/2016)
Phil Parkin (6/21/2016)Do you have a view on when they should be used in preference to environment variables?
Thanks Phil!
Environment Variables are easier to change and appear (to me)...
June 21, 2016 at 3:59 pm
brianconner (6/21/2016)
I am having a hard time importing a text file that was given to me that is delimited by 3 pipes.
I am manually importing by right clicking on...
June 21, 2016 at 9:37 am
How about selecting one pipe as your delimiter and then throwing away the empty columns?
June 21, 2016 at 9:25 am
Viewing 15 posts - 7,006 through 7,020 (of 13,876 total)