Hi,

I am looking for a sample batch file (Content to be placed inside a batch file) to download a file using wsftppro.
Can someone help me with...

Hi,

I am transferring data from SQL table to Oracle table.

For this I am using a script task in SSIS.This is working fine. Now i need to encrypt a sensitive column...

Hi,

I need to load data from SQL table into Oracle Table.In that one of the column should be encrypted and stored in oracle table.How to achieve this in SSIS.I have...

Hi ,

I am having similar kind of requirement.

I have a table.

create table dbo.test(ID int,Price decimal(18,9), Qty decimal(18,9))

Insert into dbo.test values(1,5000,5000000)

Insert into dbo.test values(2,3000,50000000)

Insert into dbo.test values(3,100,50000)

I need the output in...

Hi ,

I am having similar kind of requirement.

I have a table.

create table dbo.test(ID int,Price decimal(18,9), Qty decimal(18,9))

Insert into dbo.test values(1,5000,5000000)

Insert into dbo.test values(2,3000,50000000)

Insert into dbo.test values(3,100,50000)

I need the output in...

Hi,

In C: drive i have many folders .

For example folders named like ABC,ARD,AVB,BGT,BHT etc...And these folders has many subfolders and files in it.

My Task is to search for a string...

Thanks guys for all your valuable suggestions. Will give it a try by using script task..

Hi All,

I found a way to query the Active Directory service to query the list of groups and the users assigned to that domain groups.

You can get the list...

Hi,

As mentioned below i need to convert varchar field to varbinary in SSIS.Please suggest.

PS : *)Cannot use Staging table.

*)Sensitive data(in my case SSN)...

Thanks for your reply.

The problem I cannot use a staging table since the data is sensitive data.

Hi,

I am facing similar kind of problem.I have an SSIS package which has a flat file source and an oledb destination.

I am transferring flat file content to a table.This SQL...

Hi,

I need to know the list of users who fall under a particular Role.

For example there is a role named :SQLDEVADMINS.

I want to know the list of users who fall...

Yes you are right.Thanks for your reply

Hi,

I created Master Key,Certificate and Symmetric Key.

Both Encrypt and decrypt works fine.But the issue is though the View definition on symmetric key is granted only to me,other users also are...

Hi,

I created Master Key,Certificate and Symmetric Key.

Both Encrypt and decrypt works fine.But the issue is though the View definition on symmetric key is granted only to me,other users also are...