Remove the 'go' after 'use master' and try again.

As the 'Google Analytics source'...

komal145 (6/22/2016)

---

hi, Can anyone walk through step by step?

I get so many errors when I copy.isapc file from VS 2012 ssis project and upload existing package to VS2013. Not recognizing...

jasona.work (6/22/2016)

---

So, I'm curious, and I'm also tempted to spin this up in another topic as I suspect this is a contentious issue, what's everyone's feelings / opinions on the...

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!...

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...

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...

Are your databases really called TempTable and TempTable1?

Andy Leonard (6/21/2016)

---

Thanks Phil!

Environment Variables are easier to change and appear (to me)...

brianconner (6/21/2016)

---

Hi All,

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...

How about selecting one pipe as your delimiter and then throwing away the empty columns?

SQL!$@w$0ME (6/21/2016)

---

Hi Folks,

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...

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.

Johan_1975 (6/21/2016)

---

Hello,

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...

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...