Smash125 (7/15/2012)

---

Import fails when i try to import the flat file to data base

i have used AdventureWorks database to test this scenario

Steps:

1. Imported Production.Product table from AdventureWorks database to...

I have been working on a Data Warehouse Project since October 2011.

I believe that considering SQL Server 2012 is a viable option considering it will probably take a while before...

I was able to setup the Linked Server to Oracle so I would consider this post closed.

Thanks for all of the input.:-)

I found a solution at the following URL:

http://stackoverflow.com/questions/307636/how-do-you-setup-a-linked-server-to-an-oracle-database-on-sql-2000-2005

EXEC sp_addlinkedserver

@server = '{Linked Server Name}'

,@srvproduct ...

I forgot to create the TNS_NAMES Environmental Variable.

I also had to reboot before I could test the DSN.

Post Closed.

The 64 bit installs the ODBC Drivers.

Post closed.

Dev (7/15/2012)

---

What about an UPDATE?

UPDATE Table_Name

SET Column_Name = Column_Name -- fake update

WHERE 1 =...

Paul,

I need to do it within an SSIS Package.

I could truncate a table and insert the count into table but that is Kinda silly.

So it looks like I need to...

I looks like I need the 64 bit Oracle Client Install to get the ODBC Driver.

I may need to use a Linked Server but I was hoping that was not...

Thanks a lot Gail!:cool:

GilaMonster (7/14/2012)

---

For the second, since you want to encrypt at source, you'll need some 3rd party encryption tool, or the use of encrypted connections. SQL column encryption won't help with...

GilaMonster (7/14/2012)

---

Depends, what are you protecting against?

Yes.

Do you want to ensure that if...

Gift Peddie (7/13/2012)

---

There are known issues with the x64...

It appears that the OP wants...

I ended up going with the following:

TO_CHAR(RCT_RDB_ENTRY_DATE,'YY-MON-DD HH24:MI:SS') AS RCT_RDB_ENTRY_DATE