I'm not sure it will looks good, but back to original question
you can split your text by " " (space) and when reassemble line back insert new line after every 5 array alements
Just add script task and in VB or C#
if your file YourFileName.csv_2015-12-09_21-17-47.zip
In VB it would be
Dim fileFolder As String
Dim dirDest As DirectoryInfo = New DirectoryInfo(fileFolder)
For Each f In GetFiles("YourFileName.csv*.zip")
' unzip your file there
Next
use recordset example with your code will be
<html>
<body>
<%
PaxName = "antony"
set myconn = Server.CreateObject("ADODB.connection")
connection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &_
Server.MapPath("x\db.mdb") & ";"
myconn.open (connection)
set rs =...
I hope you understand risk of SQL injection when using inline insert statement
what if
PaxName = "antony; delete from PaxName;"
sql = "INSERT INTO table (PaxName) VALUES ('" & PaxName & "')"
In your case it will give you sql error, but code executes on database side, so it will delete all...
The simple way is something like that
in Data flow source you running SQL somthing like
select field1,
field2,
field3,
field4,
field5,
field6,
field7,
...........
fieldN
from sourceTabel
You need to change
to
Declare @LastImportDate date
select @LastImportDate = value
from ParamSettings
where...
I would say it is really simple.
create table to held view name and status flag
something like
create table myViews as
(
veiwName varchar(200) not null,
status_cd char(1),
primary key (dndveiwName)
)
1. create SSIS package
2. Add package variable vieName (string) and variable isLast string...
try something like that
If ds.Tables,Count > 0 Then
if ds.Tables(0).Rows.Count > 0 then
Dim dr As DataRow = ds.Tables(0).Rows(ds.Tables(0).Rows.Count - 1))
t1.Text = dr.Item(0).ToString
end if
End If
or preferable change your query to
"select top 1 field from table order by field...
IS step which giving error update records? If not make sure you use (nolock) attribute when query tables. Search on server log what else running on server at the same time may be problem not in your ssis, but on another process.
it looks like to stand alone queries
so first one should be something like
; with e as
(
select MIN_anty_pymt_dt = min(anty_pymt_dt),
recip_ssn_nbr
from dsnp.pr01_t_anty_pymt
GROUP BY recip_ssn_nbr
)
SELECT a.RECIP_SSN_NBR,
CASE
when a.RECIP_TYPE_CD = '10'...
It is number of ways to handle identity columns in replication (if you use identity columns). Even if you not doing anything when you set up replication system will create additional columns with and system tables which will track and handle all conflicts It is works pretty well.
It is transparent. I used that architecture. One server in central office and servers in different locations witch connected to internet and running VPN into central office network.
cross apply is analog to inner join, it works created to work with table valued functions
if query
select F.* from sys.objects O
inner join dbo.myTableFun(O.name) F
on F.schema_id= O.schema_id
giving syntactic error
query
select F.* from sys.objects O
cross apply dbo.myTableFun(O.name) F...
Is that one file with multiple tabs or multiple excel files?
if it is one file, file will be on lock until all data flow tasks completed. you should put all your data flow tasks in one Sequence Container and File System Task after Sequence Container
this is your solution...
declare @Table as table
(
UniqueRecord int,
Phone int,
[Type] varchar(20),
[Status] varchar(20)
)
insert into @Table
select 101, 5551111,'Tech', 'Closed'
union
select 102, 5552222,'CS', 'Closed'
union
select 103, 5553333,'Support', 'Pended'
union
select 104...
Yes Chris absolutely right...
you can stick somewhere in javascript array of holidays and check against that array or use ajax call from javascript to server with selected value and get from another asp page on server result
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.