Arjun.Thank you very much. I am satisfied. Thats what I've looked for.

Hi,

Output should be in separate columns per row.

customernumber lastvisit date ...

Hi,

Are you sure that I can MAX varchar ?

I don't know how to do it. Sorry.

Thanks Arjun,

but I still need all columns.

columns are:

customernumber

lastvisitdate

nr (1)

nr (2)

nr (3)

row -> 100000,10.feb.2010, New York, London, Paris

here u r:

use databasename

go

CREATE TABLE TEST2

(

Customernumber int NOT NULL,

LastVisitDate datetime...

Hi, thanks for your answer.

What is my problem?

Instead of numbers I have notes.

Each customer has some notes. Sometimes it is one note, sometimes more than one on the...

thank you. It works now.

It doesn't work.

What I did?

Select left('zip and city',charindex(' ',''zip and city'')-1) as ZIP,

right(''zip and city'',len(''zip and city'')-charindex(' ',''zip and city''))as City

into NewCustomer

from customer

and I got 2 derived columns...

Hi, thanks. I am begginer and really don't know how to do it.

Just I have table with customer data, where I have column zip code and city.

I'd like to create...

thanks, but how to do it in integration services?

Which data flow transformation I have to use?

This is a tip. I had to post it because all explanation on forum are not detailed and I couldn't make this yesterday alone. I spent time reading a...

You can use function.

{ fn week (your date) }

examples:

fn week

fn dayname

fn monthname

Create linked server in managment studio, then just make SSIS load data from ole db source (linked server tables) to ole db source in data flow.

Thank you. It works fine. : )

Use conditional split before destination.

Create variable.Then open conditional split transformation editor make condition with column name.

for example.

order: 1

output name : write variable name

condition: column name <> 38

thats all.

Just use execute process task. Open Process, then in executable make path to winrar.exe.

In arguments make path to zip file. (for ex. -e c:\temp\file_name.zip).

In working directory make c:\temp

Or, you can...