Viewing 15 posts - 7,006 through 7,020 (of 13,876 total)
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
SQL!$@w$0ME (6/21/2016)
I have a requirement for a table refresh (truncate/load) that needs to happen daily from Oracle to SQL. The table is relatively small. What is the best approach...
June 21, 2016 at 9:01 am
1) Create a connection from SSIS server to the Citrix server.
2) Set up data flow component (or whatever means you want to use to transfer the data)
3) Run package.
June 21, 2016 at 6:39 am
Johan_1975 (6/21/2016)
We're Tuesday. It's important for what's coming.
I encountered an issue on the DATENAME function and need some help.
If I type :
SELECT DATEPART(dw,GETDATE())
It returns 2 (for Tuesday)
If I type...
June 21, 2016 at 6:37 am
Well done for tackling this topic, Andy.
I use SSISDB environments a lot, but have never used parameter overrides. Do you have a view on when they should be used in...
June 21, 2016 at 6:23 am
Viewing 15 posts - 7,006 through 7,020 (of 13,876 total)